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
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.
Why not build the index on SalesOrderHeader to index SalesOrderDate and include SalesPersonID and Subtotal instead?
agree
I Agree with william852
I agree too with Williams852
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?