Could be any of many reasons.
Are there up-to-date statistics on the table?
How many records in the table?
How many records meet your WHERE condition?
Is the table partitioned?
Is the table being JOINed to another table (Hash-join, Merge-Join)?
-----Original Message-----
From: Padmanabhan S
[mailto:oracledba-ezmlmshield-x30240491.[Email address protected]
Sent: Thursday, July 27, 2006 11: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
--
This message has been scanned for viruses and
dangerous content by OpenGaming Security System and is
believed to be clean.
Have a nice day,
This e-mail and any attachments may contain information that is confidential, proprietary, privileged or otherwise protected by law. The information contained herein is solely intended for the named addressee (or a person responsible for delivering it to the addressee). If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete it from your computer.
Oracle LazyDBA home page