You execute the following code:
You have a stored procedure that includes the following SELECT statement:
You need to create a covering index on UserInfo.
Which code segment should you execute?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Get 50% Discount on All Your Purchases
at PrepAway.com - Latest Exam Questions
This is ONE TIME OFFER
50%
Correct – A covering index is one which can satisfy all requested columns in a query without performing a further lookup into the clustered index.
https://stackoverflow.com/questions/609343/what-are-covering-indexes-and-covered-queries-in-sql-server/609346#609346
0
1