Lynn Pettis (5/9/2013)
I may be wrong, would have to test, but I don't think 6e will use an index either because of the NOT IN.
You may be right there.
Just a refresher here is #6 again.
6. Field f of a table is indexed. Which of the following query fragments is written so the index cannot be used? (Assume p1 and p2 are the correct data types for their role in each fragment.)
a. where f > :p1
b. where f between :p1 and dateadd( day, :p2, :p1)
c. where dateadd( day, :p2 , f) > :p1
d. where dateadd( day, :p2, :p1) < f
e. where f not in( select …)
The actual correct answer would that the index will be used in all of these. The difference is that the index will be scanned by some and seeked by others. 😉
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/