What are the situations when an index might not be picked up?

  1. Leading column in the index is not part of the search arguments

  2. Data types are not matching while doing a join

  3. Optimizer decides that table scan is better

  4. Index name is improper


Correct Option: A,B,C

Find more quizzes: