SQL Server Database Optimization and Query Fundamentals

Time: 00:00:00

Attempted

Not Attempted

Marked For Review

Attempted & Reviewed

Question 1 of 19

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

Select Your Answer:

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

Mark for Review

Attempted

Not Attempted

Marked for Review

Attempted & Reviewed

Current