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
Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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