You need to ensure that usp_GetCustomersByDate completes as quickly as possible

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 OPTIMIZEFOR UNKNOWN query hint.

B.
Execute the sp_recompile ‘dbo.GetCustomersByDate’ statement.

C.
Execute the ALTER INDEXIX_Cust:omers_CreationDateWITH REBUILD statement.

D.
Modify the stored procedure to include the OPTIMIZE FOR(‘1/1/2008’) query hint.