What should you modify?

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 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



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Mick

Mick

C. Though we’ve potentially buggered up data integrity by removing a unique index 🙁