You work as a database administrator at ABC.com. ABC.com makes use of SQL Server 2008 R2.
ABC.com has a database that contains a table, named ABC_Item, which has numerous columns
including Name, ItemLine, ListPrice, Class, and Style. There is a standard query for the ABC_Item
table that searches for information based on these columns. There is also another standard query
specifying the Name column for the ORDER BY clause.
While in the process of reducing storage for the indexes, you are informed that the most common
searched to ABC_Item should be retained. To achieve this, you want to configure an index for the
Name column.
Which of the following actions should you take?
A.
You should consider making use of a non-clustered index.
B.
You should consider making use of a clustered index.
C.
You should consider making use of a filtered index.
D.
You should consider making use of an XML index.
Explanation: