Multiple choice

When could an index decrease the speed of a query?

  1. The column is used in a WHERE clause.

  2. The column contains a wide range of values.

  3. The table is small.

  4. The column contains a large number of null values.

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

The table is small.