Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Forcing use of an index
I tried the query without the leading % with some data I knew was there
and good. the query went from 11 seconds to .013 second. Since I have
to do several thosand of these at a time against a table with a million
+ rows speed is important.
Received on Thu Mar 17 2005 - 07:31:59 CST
![]() |
![]() |