You work as a database administrator at ABC.com.ABC.com is using a SQL Server 2008 R2
instance that contains a database, named ABCBooks.
ABCBooks includes the BookTitle, EANNumber, SellingPrice and IssueDate columns. A clustered
index is configured for the BookTitle column and a non-clustered index, which includes the
EANNumber and SellingPrice columns, is configured for the IssueDate column.
A Transact-SQL query, which includes a query hint, searches the ABCBooks table for BookTitle,
EANNumber, SellingPrice, and IssueDate data. During monitoring you notice that the query’s
performance is slow. You then run the sys.dm_db_index_physical_stats dynamic management
function (DMF) and find that the avg_fragmentation_in_percent is in excess of 25%.
You have been instructed to find a solution to improve the query’s performance.
Which of the following actions should you take?
A.
You should consider having the table hint inserted.
B.
You should consider having the query hint removed from the query.
C.
You should consider having the primary key modified.
D.
You should consider having a filtered index created.
Explanation: