You are the administrator of a SQL Server 2000 computer. The server contains a database na
In the last six months, the database has grown by 4 GB. Users report that query response time has slowed. The options set up on the database are shown in the Database Options exhibit.
You want to accelerate query response time. What should you do?
A.Update the database statistics.
B.Add indexes to the foreign key fields.
C.Truncate the transaction log.
D.Run the database maintenance plan wizard.
E.Drop primary keys from all tables.