SQL Server Database Optimization and Query Fundamentals

Casual Mode - Take your time!

1 / 19
✓
Correct
0
✗
Incorrect
0
★
Score
0%
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