Re: full-scan vs index for "small" tables

Connor wrote:
>>In my experience, [spinning in memory] is all too common... in particular queries to dual
>>- heaps and heaps of
>>select user from dual
>>...dual...dual....dual....dual....dual.....aarrrggghhh!

I'll vouch for that; my top SQL by executions is:

    select 'x' from dual;

with 311,972 executions in a recent load test; next SQL has 95,921. This was just under 10% of total executes and 44% of all parses. The statement is issued by the (Oracle 10.1.0.4) JDBC driver whenever we get a connection out of the pool.  

It's allegedly fixed in JDBC 11 (yes, 11) see bug 4601037 and my writeup of the conversation with Oracle at http://preferisco.blogspot.com/2006/04/is-this-oracle-wtf.html.  

Regards Nigel    

--
http://www.freelists.org/webpage/oracle-l