You have the following query on a disk-based table:
You discover that the query takes a long time to complete.
The execution plan is shown in the Execution Plan exhibit. (Click the Exhibit button.)
The index usage is show in the Index Usage exhibit. (Click the Exhibit button.)
You need to reduce the amount of time it takes to complete the query. You must achieve this
goal as quickly as possible.
What should you do?
A.
Reorganize the index.
B.
Update statistics.
C.
Create an index on LastName.
D.
Rebuild the index.