Monday, March 1, 2021

SQL Server / Ola Hallengren: Re-create statistics

EXECUTE dbo.IndexOptimize
@Databases = 'USER_DATABASES'
,@FragmentationLow = NULL
,@FragmentationMedium = NULL
,@FragmentationHigh = NULL
,@UpdateStatistics = 'ALL'
,@StatisticsSample=100

No comments:

Post a Comment