A type mismatch that costs a scan

• A

  The comparison forces a conversion on the column side, which the index cannot follow

• B

  The number is too large for the column

• C

  Comparing a string against a number is an error that the database is silently ignoring here

• D

  The index needs to be rebuilt after a type change