You are the administrator of SQL server 2000 computer. The server contains a database name
You want to accelerate query response time and minimize administrative overhead. How should you reconfigure the database?
A.Create a SQL Server Agent job to execute the UPDATE STATISTICS statement, and schedule the job to run weekly.
B.Select the Auto Update Statistics check box.
C.Run the database maintenance plan wizard, and accept the default settings.
D.Rebuild the primary key as a nonclustered primary key.
E.Clear the Auto Create Statistics check box.