Multiple choice

Which of the following type of segments is used to improve the performance of a query?

  1. Index

  2. Table

  3. Temporary

  4. Boot strap

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

Index segments store sorted copies of indexed columns, allowing Oracle to locate rows without scanning entire tables. This dramatically improves query performance, especially for large tables with selective WHERE clauses. Tables store actual data, temporary segments hold intermediate query results, and bootstrap segments contain internal metadata - none exist primarily for query performance enhancement.