Do send me the query,
Thanks,
Biswajit

-----Original Message-----
From: Padmanabhan S
[mailto:oracledba-ezmlmshield-x30240491.[Email address protected]
Sent: Thursday, July 27, 2006 1:36 PM
To: LazyDBA Discussion
Subject: composite index problem




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


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page