You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2005 database that contains a table named CK_Prod. Product, that has over 50 columns. The
normal Transact-SQL statement queries are as follows:
–QUERY 1
SELECT [Name], [ProductLine], [ListPrice], [Class], [Style] FROM [CK_Prod]. [Product]WHERE
[ProductLine] = ‘T’
–QUERY 2
SELECT * FROM [CK_Prod]. [Product] ORDER BY [Name]
You have received instructions to minimize the space for the indexes, however, you should keep
the most common searched to CK_Prod. Product.
What should you do?
A.
You should consider creating a clustered index on the ProductLine, ListPrice, Class and Style columns.
B.
You should consider creating a clustered index on the Name column.
C.
You should consider creating a nonclustered index on the Name column.
D.
You should consider creating a nonclustered index on the ProductLine, ListPrice columns.