You have the following query on a disk-based table: You discover that the query takes a long time to complete. The exec

[answerhappygod]

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?

You Have The Fo 1 (19.12 KiB) Viewed 92 times

You Have The Fo 2 (8.76 KiB) Viewed 92 times

You Have The Fo 3 (64.46 KiB) Viewed 92 times

A. Reorganize the index.
B. Update statistics.
C. Create an index on LastName.
D. Rebuild the index.