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?