Multiple choice technology databases

How can you avoid indexes ?

  1. Use FULL hint to optimizer for full table scan

  2. Use INDEX or AND-EQUAL hint to optimizer to use one index or set to indexes instead of another.

  3. Use an expression in the Where Clause of the SQL.

  4. Disable Index on the column
Reveal answer Fill a bubble to check yourself
A,B,C,D Correct answer
Explanation

In SQL optimization, you can prevent index usage (avoid indexes) by: forcing a full table scan via the FULL hint, forcing a different index with INDEX or AND-EQUAL hints, using expressions on index columns (e.g. col + 0 or to_char(col)) which disables index usage, or disabling/dropping the index.

Keep practicing — related questions