Re: Optimizer problems
From: Avinash Deshpande <avdeshpa_at_cisco.com>
Date: 1998/01/05
Message-ID: <34B12EC4.2DF3_at_cisco.com>#1/1
Date: 1998/01/05
Message-ID: <34B12EC4.2DF3_at_cisco.com>#1/1
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 CET