You need to create one index to minimize the amount of time it takes to execute the query

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

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

Answer: See the explanation

Explanation:
Box 1:

Box 2:

Box 3:

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 5

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


william852

william852

Why not build the index on SalesOrderHeader to index SalesOrderDate and include SalesPersonID and Subtotal instead?

krishtweety

krishtweety

agree

gabino

gabino

I Agree with william852

FALGUNKUMAR PATEL

FALGUNKUMAR PATEL

I agree too with Williams852

mickeyW

mickeyW

Would be better to Index SalesOrderHeader 1st by ‘OrderDate’ and 2nd by ‘SalesPersonID’ (to Support the join with the EmployeeTabel) and only include ‘Subtotal’, isn’t it?
Is it only because of the fields in the Answer Area, that the ‘SalesPersonID’ to be allocated only to the Include columns?