Ask the Expert

LOCAL vs. GLOBAL partitioned table

What are the factors in which we decide whether to create a LOCAL or GLOBAL partitioned index on a partitioned table?

    Requires Free Membership to View

Basically, if the index is created on the same columns that the table is partitioned on, the index should be created as a LOCAL index. If the index is created on other columns, then it must be a GLOBAL partitioned index.

This was first published in March 2004

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.