If you're using the cost-based optimizer (most likely you are), you need
to make sure that you have analyzed your table first, as the CBO depends
on this table. If your statistics are up to date but your table is
rather small, perhaps the CBO has determined that it is more efficient
to perform a full table scan rather than an index lookup.


-----Original Message-----
From: Padmanabhan S
[mailto:oracledba-ezmlmshield-x30240491.[Email address protected]
Sent: Thursday, July 27, 2006 2:06 AM
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