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

Oracle LazyDBA home page