Hello DBAs,

This question is bugging me for a while and I cannot fins any answer for
it.
I have a table with 126 partitions in it. When I run my query ( the
following on) it uses the full table scan instead of using index.
I am wondering what is the reason because if it uses the index the
performance is different.
How can I force it to use index in partition.

SELECT PRODKEY
FROM SALES_LEVEL DATA
WHERE DATA.MKTKEY IN (74) AND
DATA.PERKEY IN (2003121301) AND
DATA2.DOLLARS > 50000

There is index for PRODKEY, MKTKEY ,PERKEY and DOLLARS .

EXECUTION PLAN:

SELECT STATMENT ALLROWS
PX COORDINATOR
PX SEND(QC (RANDOM) SYS:[Email Address Removed] PX BLOCK(ITERATOR)
TABLE ACCESS(FULL)


Thanks for your advise,

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

Oracle LazyDBA home page