You are a database developer. Your company has a centralised OLTP database located on a SQL Server 2000 computer. This databas has a table named Sales. During the last year more than 150,000 rows have been added to the sales table. Users of hte database report that performance has decreased over the course of the year. You need to improve performance of queries against the sales table. In SQL Query Analyser, which script should you run?

93.

You are a database developer. Your company has a centralised OLTP database located on a SQL Server 2000 computer. This databas has a table named Sales.

During the last year more than 150,000 rows have been added to the sales table. Users of hte database report that performance has decreased over the course of the year.

You need to improve performance of queries against the sales table. In SQL Query Analyser, which script should you run?

EXEC sp_updatestats 'resample'

CREATE STATISTICS Sales WITH FULLSCAN

sp_autostats 'Sales'

UPDATE STATISTICS Sales WITH FULLSCAN ALL

View Description

150,000 rows have been added. We should make sure that statistics are up to date. We could either update or create them.

The sp_updatestats command runs UPDATE STATISTICS on all uesr defined tables. It may seem excessive to update stats on all user tables but no alternative is correct.

Options B & D contain incorrect syntaxes.