题目内容
(请给出正确答案)
[主观题]
You are the administrator of SQL server 2000 computer. The server contains a database name
d MedicalRecords. Users access medical records by using the PatientID field. This field is the clustered primary key for the Patients table. When users try to access medical records, the database responds slowly. You examine the database options as shown in the exhibit.
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.
如搜索结果不匹配,请 联系老师 获取答案