Which of the following DBCC command is used to see when was the last time the index rebuild?

Options
- DBCC SHOW_STATISTICS
- DBCC SHOWCONFIG
- DBCC DBREINDEX


CORRECT ANSWER : DBCC SHOW_STATISTICS

Discussion Board
DBCC SHOW_STATISTICS

DBCC SHOW_STATISTICS command is used to see when was the last time the index rebuild. DBCC SHOW_STATISTICS displays current query optimization statistics for a table or indexed view. The query optimizer uses statistics to estimate the cardinality or number of rows in the query result, which enables the query optimizer to create a high quality query plan. DBCC SHOW_STATISTICS displays the header, histogram, and density vector based on data stored in the statistics object.

Prajakta Pandit 03-8-2017 02:05 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement