Andrew works as a Database Administrator for Miracle Infocom. The company has a SQL server 2005 computer. The computer has a database named Purchase. Andrew creates a table named products. He writes some queries that are used to insert and update data in the table and delete data from the table. He now wants to check the performance of the queries. Which of the following will he use to accomplish the task?
A. A.SP_UPDATESTATS
B. B.SP_AUTOSTATS
C. SYS.DM_EXEC_QUERY_STATS
D. D.SYS.DM_DB_INDEX_PHYSICAL_STATS
Answer:C
Andrew works as a Database Administrator for Miracle Infocom. The company has a SQL server 2005 computer. The computer has a database named Purchase. Andrew creates a table named products. He writes some queries that are used to insert and update data in the table and delete data from the table. He now wants to check the performance of the queries. Which of the following will he use to accomplish the task?
A. A.SP_UPDATESTATS B. B.SP_AUTOSTATS C. SYS.DM_EXEC_QUERY_STATS D. D.SYS.DM_DB_INDEX_PHYSICAL_STATS