You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which contains a database named DBx1. There’s a table calledd TPV in DBx1 database.
This table is used to store information on all kinds of TPV cars. Users query the TPV table based on the BikeSize column frequently. Besides the NULL value for bikes, the BikeSize column also has the NULL value for all products. At present no index is related to the BikeSize column. Now you have to improve the query performance, meanwhile you must reduce the effect on the disk space to the least. So what should you do to ahieve this?
A.
You should create a clustered index on the BikeSize column.
B.
You should create filtered index on the BikeSize column.
C.
You should create a unique clustered index on the BikeSize column.
D.
You should create a view on the Products table by filtering on the BikeSize column.