DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Partitioned table

  1. #1

    Question

    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

  2. #2
    Join Date
    Nov 2000
    Posts
    212
    check with explain plan. According to docs, partition pruning works only with cost based optimizer mode

  3. Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •  


    Click Here to Expand Forum to Full Width