Community

Query To Retrieve Statistics Data: dm_db_stats_histogram

(Grant Fritchey) Starting with SQL Server 2016 Sp1 CU2, a new way of directly querying statistics, specifically the histogram, has been introduced: dm_db_stats_histogram. We’ve always been able to query the statistics using DBCC SHOW_STATISTICS.