yochananrachamim / AzureSQL

129 stars 61 forks source link

Statistics maintenance go through all statistics regardless mode option #16

Closed yochananrachamim closed 3 years ago

yochananrachamim commented 3 years ago

Thank you to Nag Reddipalle for reporting the issue in Tech Community page.

https://techcommunity.microsoft.com/t5/azure-database-support-blog/automating-azure-sql-db-index-and-statistics-maintenance-using/bc-p/2024597/highlight/true#M429

yochananrachamim commented 3 years ago

The issue is caused by wrong condition used when pulling the list of statistics.

yochananrachamim commented 3 years ago

The issue if now fixed in current version.