Millionaire Mode

SQL Server Database Optimization and Query Fundamentals

Question 1 of 19

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

Prize Money

15₹7 Crores
14₹1 Crore
13₹50,00,000
12₹25,00,000
11₹12,50,000
10₹6,40,000
9₹3,20,000
8₹1,60,000
7₹80,000
6₹40,000
5₹20,000
4₹10,000
3₹5,000
2₹2,000
1₹1,000