I have a very big table partitioned by range and created a partitioned index on it.
TABLE ( P1 values less than 10,
P2 values less than 20,
P3 values less than 30,
P4 values less than MAXVALUE
)
INDEX ON (id) LOCAL ( PARTITION I1, I2, I3, I4 );
If I run the following query:
SELECT * FROMWHERE id BETWEEN 12 AND 25;
Will it scan all the index partitions or just scan index I2 and I3?
04-02-2001, 12:46 PMLNDcheck with explain plan. According to docs, partition pruning works only with cost based optimizer mode