AzureSQL icon indicating copy to clipboard operation
AzureSQL copied to clipboard

Add support for "per table" settings for stats update

Open yochananrachamim opened this issue 2 years ago • 2 comments

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.

yochananrachamim avatar Jan 30 '23 09:01 yochananrachamim

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.

sopelt avatar May 03 '23 09:05 sopelt

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"

akobuspl avatar Sep 05 '23 10:09 akobuspl