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
Which code segment should you execute?
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?
Covering index is just an ordinary index. It’s called “covering” if it can satisfy query without necessity to analyze data.