Multiple choice

Which of the following is the simplest and also substantial means to improve performance of Oracle using partitioning?

  1. Partition-wise joins

  2. Partitioning pruning

  3. Global partitioned indexes

  4. Composite range hash partitioning

  5. Global non-partitioned indexes

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This is the simplest and also the most substantial means to improve performance of Oracle using partitioning. It improves query performance by several orders of magnitude.