Skip to content

Latest commit

 

History

History

README.md

Statistics

Scripts for analyzing column and index statistics.

Identifies and generates DDL to drop redundant auto-created statistics on columns that now have index statistics.

Comprehensive statistics report showing column statistics with last update time, rows modified, modification counter, and DDL for update/drop operations.

Legacy statistics analysis for SQL Server pre-2012 using sysindexes DMV, showing statistics age and modification rates to identify stale statistics.

Lists user-created (manual) statistics with columns, last update time, and DDL for dropping unused statistics.