You have database objects that were created by using the following script:
The dbo.Customers table has 1 million rows.
You discover that usp_GetCustomersByDate takes a long time to complete.
The query plan used by the stored procedure is shown in the exhibit. (Click the Exhibit button.)
You need to ensure that usp_GetCustomersByDate completes as quickly as possible.
What should you do?
A.
Modify the stored procedure to include the OPTIMIZE FOR UNKNOWN query hint.
B.
Execute the sp_recompile ‘dbo.GetCustomersByDate’ statement.
C.
Execute the ALTER INDEXIX_Customers_CreationDate WITH REBUILD statement.
D.
Modify the stored procedure to include the OPTIMIZE FOR(‘1/1/2008’) query hint.