-
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?
Queyon Zeng
-
check with explain plan. According to docs, partition pruning works only with cost based optimizer mode
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Click Here to Expand Forum to Full Width
|
|