______________ runs UPDATE STATISTICS against all user-defined tables in the current database.
A. sp_updatestats
B. DBCC CHECKDB
C. DBCC CATALOG
D. DBCC INDEXDEFRAG
Answer:A
______________ runs UPDATE STATISTICS against all user-defined tables in the current database.
A. sp_updatestats B. DBCC CHECKDB C. DBCC CATALOG D. DBCC INDEXDEFRAG
Explanation:sp_updatestats updates all statistics for all tables in the database.