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.