search

yochananrachamim / AzureSQL

132 stars 61 forks source link

Add support for "per table" settings for stats update #34

Open yochananrachamim opened 1 year ago

yochananrachamim commented 1 year ago

for scenario where we have large tables and we do not want to go through all the data for the stats update it would help to have some control for per table settings that will set the percentage of the scan while updating stats.

sopelt commented 1 year ago

This would also be nice for index operations. In niche cases (large tables that are just appended to and rarely read) excluding by table would be great.

akobuspl commented 1 year ago

I'd vote for possibility to exclude either a specific table or specific statistics. It happens that some column statistics which are not having big value are causing statistics update takes "forever"