Post reply

Statistics - All Density information

  • August 20, 2019 at 8:09 pm

    #3672915

    Does anyone out there know the system table (if it exists) where SQL Server stores the All Density column for a particular statistic?  This is the information you get when you run DBCC SHOW_STATISTICS (tablename, indexname), but I'd rather be able to query the same information out of a table.

    Anyone know exactly where that information is stored?

    Thanks,

    Robert

  • August 20, 2019 at 8:53 pm

    #3672922

    In a blob column (imageval) in sys.sysobjvalues that you would need to connect with the DAC to query. And then you just have the blob and could probably get some further information by using DBCC PAGE on pages for sysobjvalues. But no, not a table, view to just query. Use DBCC SHOW_STATISTICS

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply