NOT operator is used in the predicate

IN Operator is used in the predicate

Expression and/or functions are used on the indexed columns

Predicate is skipped. However, the SELECT clause has indexed columns

ORDER BY clause has NULL columns. However, NON UNIQUE index exists