未分类题You are the administrator of a SQL Server 2000 database. Using the default options configures the database. You drop indexes to facilitate a large import of data, and rebuild them after the import is complete.Users report that response times from a stored procedure have become slower. In the stored procedure, you examine the following code.CREATE PROCEDURE GetCustomer( @CustomerID Int )ASSELECT FirstName, LastName, Address1, Address2, City,State, Zip, MAX(PurchaseDate) AS LastPurchaseFROM Customers CJOIN Addresses A ON A.AddressID = C.AddressIDJOIN Purchases P ON P.CustomerID = C.CustomerIDWHERE C.CustomerID = @CustomerIDGROUP BY FirstName, LastName, Address1, Address2, City, State, ZipYou want to improve the performance of the procedure by using the least amount of administrative effort. What should you do?A.Recompile the stored procedure.B.Update the database statistics.C.Check the consistency of the database and repair errors.D.Create a view and modify the stored procedure to use the view.