The first result set of the DBCC SHOW_STATISTICScommand returns the header information, including when the statistics were last updated. The following example returns all statistics information for the IXC_ServerChecks_Results_LoadID index of the ServerChecks.Results table.ĭBCC SHOW_STATISTICS('ServerChecks.Results' STAT_HEADER | DENSITY_VECTOR | HISTOGRAM | STATS_STREAMĮxample: Returning all statistics information The syntax lets you specify a table or indexed view along with a target index name, statistics name, or column name (see below):ĭBCC SHOW_STATISTICS (table_or_indexed_view_name Through STATS_DATE() function and sys.stats system catalog view.ġ) Through the header information using DBCC SHOW_STATISTICSĪccording to Microsoft Books Online, DBCC SHOW_STATISTICS returns the header, histogram, and vector density based on the data stored in the statistics object.Through the header information using DBCC SHOW_STATISTICS.Well, in SQL Server, there are two ways to access the last modified date of a statistic, which are:
I received an email from friend today asking how he can see when statistics were last updated in SQL Server.
0 kommentar(er)
