DRAG DROP -
You have a database that contains three tables. The tables are configured as shown in the following table.
You have the following query:
The execution plan for the query is shown in the exhibit. (Click the Exhibit button.)
You need to create one index to minimize the amount of time it takes to execute the query.
What should you do?
To answer, drag the appropriate columns to the correct locations in the answer area. (Answer choices may be used once, more than once, or not at all.)
Select and Place:
Drag Drop You H 1 (39.22 KiB) Viewed 102 times
Drag Drop You H 2 (64.79 KiB) Viewed 102 times
Drag Drop You H 3 (30.86 KiB) Viewed 102 times
Drag Drop You H 4 (34.98 KiB) Viewed 102 times
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!