You have database objects that were created by using the following script: The dbo.Customers table has 1 million rows.

[answerhappygod]

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?

You Have Databa 1 (120.24 KiB) Viewed 91 times

You Have Databa 2 (62.26 KiB) Viewed 91 times

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.