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 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.
B. Use a partitioning function to partition the Claims table on the open_date column.
C. 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.
D. 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.
