Multiple choice technology packaged enterprise solutions

Indexes are not used during query execution in which of the following cases?

  1. Single value is selected

  2. Value range is selected

  3. Single value is excluded

  4. None

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

When a query excludes a single value (e.g., using NOT EQUAL or !=), database optimizers typically perform a full table scan rather than using an index, because almost all rows must be retrieved.