The index that the query ignores

• A

  The index sits on a date column, and indexes on dates cannot be range-scanned at all

• B

  SELECT * prevents index usage because every column must be read

• C

  The column is wrapped in a function, so the index on the raw column no longer applies

• D

  The statistics are stale and the planner has underestimated the index