You administer a SQL Server 2008 instance that contains a database named Sales. The
Sales database has a table named Products that stores information about all types of
products. Users frequently query the Products table based on the TelevisionSize column.
The TelevisionSize column has the NULL value for all products other than Televisions.
There is currently no index on the TelevisionSize column. You need to improve the query
performance by ensuring that the effect on the disk space is minimized. What should you
do?
A.
Create a filtered index on the TelevisionSize column.
B.
Create a clustered index on the TelevisionSize column.
C.
Create a unique clustered index on the TelevisionSize column.
D.
Create a view on the Products table by filtering on the TelevisionSize column.
Explanation: