📚 Practice Mode

SQL Server Database Optimization and Query Fundamentals

Learn at your own pace with hints and detailed explanations

1 / 19
Multiple Answers

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
Change Mode