What are the situations when an index might not be picked up?
Leading column in the index is not part of the search arguments
Data types are not matching while doing a join
Optimizer decides that table scan is better
Index name is improper