You are a database developer. You plan to design a database solution by using SQL Server
2008. The database contains a table named Claims. The structure of the Claims table is as
shown in the following table. Only two percent of the claims are open at any point in time.
You discover that queries on claims that have an Open status take a long time to execute.
You need to optimize the performance of the claim-processing queries. What should you
do?
A.
Create a view for the Claims table by using a WHERE clause to include all rows that
have a NULL value in the close_date column.
B.
Create an index for the Claims table by using a WHERE clause to include all rows that
have a NULL value in the close_date column.
C.
Use a partitioning function to partition the Claims table on the open_date column.
D.
Create a table-valued function for the Claims table by using a WHERE clause to include
all rows that have a NULL value in the close_date column.