madhaviguthula

 Profile Answers by madhaviguthula 

• Mar 9th, 2007

 

When you create a partitioned table,you should create an index on the table. The index may be partitioned according to the same range values that were used to partition the table.Local keyword in the index partitiong tells oracle to create a separate index for each partition of the table.The Global clause in create index command allows you to create a non-partitioned index or to specify ranges for the index values that are different from the ranges for the table paratitions.Local indexes may be easier to manage than global indexes however, global indexes may perfrom uniqueness checks faster than local(partioned) indexes perform them.