Multiple choice technology platforms and products

Storage indexes provide for better performance in a manner most similar to which of the following features?

  1. Materialized views

  2. Hybrid Columnar Compression

  3. Parallelism

  4. Partitioning

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

Storage indexes in Exadata provide performance optimization most similarly to partitioning. Both features work by eliminating unnecessary data access: storage indexes track min/max values in storage regions to skip entire regions during queries, while partitioning allows the optimizer to skip entire partitions. Materialized views pre-compute results, Hybrid Columnar Compression reduces storage, and parallelism distributes work across processes.