You need to create one index to minimize the amount of …

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:

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:

Answer:

Explanation:
Note:
Covering index: A type of index that includes all the columns that are needed to process a particular query. For
example, your query might retrieve the FirstName and LastName columns from a table, based on a value in the
ContactID column. You can create a covering index that includes all three columns.



Leave a Reply 0

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