Option to include UPDATE STATISTICS for filtered indexes or filtered statistics

olahallengren / sql-server-maintenance-solution

SQL Server Maintenance Solution

https://ola.hallengren.com

MIT License

2.91k stars 756 forks source link

Option to include UPDATE STATISTICS for filtered indexes or filtered statistics #761

Open oliverha opened 1 year ago

oliverha commented 1 year ago

Hi, by default, SQL Server does not update statistics for filtered indexes or for filtered statistics. These statistics will become stale pretty soon. Would it be possible to add another switch ( maybe @IncludeFilteredIndexes = 'Y' ) to include filtered indexes for statistics maintenance as well? Thank you! Regards, Oliver