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.
A.
Option A
B.
Option B
C.
Option C
D.
Option D
C. Though we’ve potentially buggered up data integrity by removing a unique index 🙁
c