You administer an instance of SQL Server 2014.
You are tasked with tuning a common set of queries. You have the results of several test
executions, along with query plans. The schema and the data for all database object(s) used
remain unchanged between executions. The QueryTime column is defined as a computed
column that uses the GETDATE() system function. The query plans and results are shown
below:
You need to make an initial diagnosis of the situation, based solely on this input
Which two statements can you make about the performance characteristics of this query?
Each correct answer presents a complete solution. Choose two.
A.
The queries would perform better if the index named AccountNumber included the Name
and QueryTime column.
B.
The queries would perform worse if the index named AccountNumber included the
NameColumn.
C.
The queries would perform better if the index named AccountNumber included the Name
column.
D.
The object Account is a table, with an index having a leading column of AccountNumber
and a Clustered Index named PKAccount.
E.
The object Account is an indexed view, with an index having a leading column of
AccountNumber and a Clustered Index named PKAccount.
F.
The object Account is a view, joining the Account-AccountNumber and
Account.PKAccount objects together.
C. D.
The queries would perform better if the index named AccountNumber included the Name
column. (No “KeyLookup”)
A & D
The queries would perform better if the index named AccountNumber included the Name
and QueryTime column. This will eliminate the need for Key Lookup.
QueryTime is calculated by Getdate(), so I think you are not able to include the column
so it should be ‘C’ + ‘D’
B and D is correct ANS