Olla Hallengren: IndexOptimize - USER_DATABASES

EXECUTE [dbo].[IndexOptimize]

@Databases = 'USER_DATABASES'

,@LogToTable = 'Y'

,@FragmentationLow = NULL

,@FragmentationMedium =  'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE'

,@FragmentationHigh = 'INDEX_REBUILD_ONLINE'

,@UpdateStatistics = 'ALL'

,@OnlyModifiedStatistics = 'Y'

,@MinNumberOfPages = 500

,@TimeLimit = 189900