You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com.
Domain.com makes use of a SQL Server 2005.
A Domain.com employee named Andy Booth is appointed as a junior technician in the Research and Development department. You have received a query from various users stating that the report execution is slow. You instruct Andy Booth to troubleshoot the error. Andy Booth discovers that some queries do not use optimal execution plans.
It has come to your attention that some optimizer statistics are missing while others are out of date. Andy Booth needs to solve this problem in order for the reports to be executed faster. Andy Booth needs to identify the Transact-SQL statements that need to be used.
What Transact-SQL statements should he use? (Choose all that apply)
A.
Andy Booth needs to use both the UPDATE STATISTICS and CREATE STATISTICS Transact-SQL statements.
B.
Andy Booth needs to use both the ALTER INDEX REORGANIZE and CREATE STATISTICS Transact-SQL statements.
C.
Andy Booth needs to use both the UPDATE STATISTICS and DBCC SHOW_STATISTICS Transact-SQL statements.
D.
Andy Booth needs to use the DBCC CHECKTABLE Transact-SQL statement.
Explanation:
When a DBA creates an index, the query optimizer stores statistical information about the indexed columns. CREATE STATISTICS will create statistics on columns that are not contained in indexes but that are used in query predicates. UPDATE STATISTICS will optimize query performance.