1.

What Is A Global Index And Local Index?

Answer»

Local Index :each partition of a local index is ASSOCIATED with exactly one partition of the table.
Global Index :global index is associated with MULTIPLE partitions of the table.

Oracle offers two TYPES of global partitioned index:

  • Global Range Partitioned INDEXES.
  • Global Hash Partitioned Indexes.


Local Index :each partition of a local index is associated with exactly one partition of the table.
Global Index :global index is associated with multiple partitions of the table.

Oracle offers two types of global partitioned index:


Discussion

No Comment Found

Related InterviewSolutions