Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- EXECUTE master.dbo.IndexOptimize @DATABASES = 'my_db',
- @FragmentationLow = NULL,
- @FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
- @FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
- @FragmentationLevel1 = 5,
- @FragmentationLevel2 = 30,
- @WaitAtLowPriorityMaxDuration = 1,
- @WaitAtLowPriorityAbortAfterWait = 'NONE'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement