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 * FROM
WHERE id BETWEEN 12 AND 25;
Will it scan all the index partitions or just scan index I2 and I3?
check with explain plan. According to docs, partition pruning works only with cost based optimizer mode
Click Here to Expand Forum to Full Width