You execute the following code: The execution plan for the query is shown in the exhibit. (Click the Exhibit button.)

[answerhappygod]

You execute the following code:

The execution plan for the query is shown in the exhibit. (Click the Exhibit button.)

You need to prevent the key lookup.
What should you modify?
More than one answer choice may achieve the goal. Select the BEST answer.

You Execute The 1 (105.4 KiB) Viewed 107 times

You Execute The 2 (33.35 KiB) Viewed 107 times

You Execute The 3 (118.77 KiB) Viewed 107 times

A. Option A
B. Option B
C. Option C
D. Option D