Do you always use columns from the same index?
Make sure you use the index's first/leading column.

-----Original Message-----
From: Tavousi Mahnaz
[mailto:oracledba-ezmlmshield-x45528690.[Email address protected]
Sent: Wednesday, May 31, 2006 2:48 PM
To: LazyDBA Discussion
Subject: Optimizer uses either index or full scan in a partitioned table


Hello,

I have a table which is partitioned.
When I run a query with different scenario and take a look at the
execution plan , oracle either uses index or full scan.
When it uses index the response time is 1 sec but when it uses table
scan the response time is 3 sec.
I have to mention that all the column I am using in my select are part
of index. I am wondering if there is any way to force the optimizer to
apply index only.

Thanks

Mahnaz Tavousi
> ACNielsen Company of Canada
> Tel: 905-475-3344 ext 2615
> e-mail: Mahnaz.[Email address protected]
>
>


--------
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