Improve statistics update

olahallengren / sql-server-maintenance-solution

SQL Server Maintenance Solution

https://ola.hallengren.com

MIT License

2.91k stars 756 forks source link

Open Hermholtz opened 1 year ago

Hermholtz commented 1 year ago

Make the IndexOptimize procedure obey values of @MinNumberOfPages and @MaxNumberOfPages.

Calculate index size by using reserved_page_count in sys.dm_db_partition_stats,
Add required conditions when deciding if statistics should be updated. Please pull.