Multiple choice technology databases

On a partitioned table which index is used mostly

  1. Local

  2. Global

  3. Both

  4. None
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Local indexes are preferred on partitioned tables because they are automatically maintained with partition operations and provide better partition pruning. Global indexes span all partitions and require more maintenance during partition operations like DROP or TRUNCATE. Local indexes align with the table's partitioning strategy.

Keep practicing — related questions