index-maintenance
Version 1.1 by Rudi Marais on 2022/02/04 15:28
Install these scripts from the maintenance package at https://ola.hallengren.com/
Documentation for the index maintenance methods can be found here: SQL Server Index and Statistics Maintenance (hallengren.com)
EXECUTE dbo.IndexOptimize
@Databases = 'Everest_PreProd',
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationLevel1 = 5,
@FragmentationLevel2 = 30,
@UpdateStatistics = 'ALL',
@FillFactor = 80,
@Execute = 'Y',
@LogToTable = 'Y'
@Databases = 'Everest_PreProd',
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationLevel1 = 5,
@FragmentationLevel2 = 30,
@UpdateStatistics = 'ALL',
@FillFactor = 80,
@Execute = 'Y',
@LogToTable = 'Y'