Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Optimizer problems
Hi,
U can check , whether the SQl uses the index using the Explain_plan
utility.
I doubt that the query uses the index . U can try writing the query w/o
the IN func & try. It should work.
Avinash
S Received on Mon Jan 05 1998 - 00:00:00 CST