Hi

I got a composite index (on two columns of my table) in a table . And in my select query , im searching with the first column in the index. But the plan shows full scan , and the index is not taken . Im using Oracle9i Enterprise Edition Release 9.2.0.6.0 in windows server . Is there any parameter to be configured additionally to achieve this ?

Regards,
Padmanabhan S






This electronic mail (including any attachment thereto) may be confidential and privileged and is intended only for the individual or entity named above. Any unauthorized use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. Accordingly, if you are not the intended recipient, please notify the sender by replying to this email immediately and delete this email (and any attachment thereto) from your computer system...Thank You

Oracle LazyDBA home page