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