I am using an Oracle 10g and have a problem when selecting a specified amount of columns. I have a Table called customer and want to read the ID (primary key, indexed aso.)
This happens only in the application and with sqltalk. Not with sqlplus or toad.
So I assume this has something to do with TD or with any setting within the runtime.
The problem occurs when selecting 86-95 columns from this table. The select lasts over 8 seconds. If i use more or less columns the selects returns within 0.03 seconds. To exclude any problems with clobs, long strings aso. I used the same column 90 times.
The select looks like:
SELECT customer_id, customer_id, customer_id, customer_id, customer_id, customer_id ... (90 times)
WHERE Customer_id = 1;
If I use the customer_id 85 times in my SELECT its fast. If I use it 96 times ist fast. If I use any amount from 86 to 95 its slow.
So my Question is if there is any setting which leads to this sorcery? And why the hell it occors between 86 and 95 and not after 85 at all.
Thank you in advance.
Who is online
Users browsing this forum: No registered users and 1 guest