Page History
...
Rebuild Online Daily Top 10
If available, rebuild online on a daily schedule the top 10 most fragmented indexes over 70%.
Rebuild Weekly All
Rebuild indexes where fragmentation is greater than 70% and page count is greater than 1,000.
Reorganize Daily All (Nightly Window)
Reorganize indexes where fragmentation is greater than 30% and page count is greater than 1,000.
Reorganize Interval Top 10%
Reorganize the top 10% of the indexes on a one-hour interval that are greater than 30% fragmented.
Reorganize Interval Top 10
Reorganize the top 10 indexes on a one-hour interval that are greater than 30% fragmented.
Reorganize Large Indexes (Nightly Window)
Reorganize the largest indexes (greater than 10,000 pages) with fragmentation greater than 70% only during the nightly maintenance window (12 am to 4 am).
To Do List Reorganize Large Indexes
Run a policy once a week to create a To Do list of large indexes (greater than 10,000 pages) that are candidates for reorganization.
To Do List Reorganize Medium Indexes
Run a policy daily to create a To Do list of medium indexes (greater than 1,000 but less than 10,000 pages) that are candidates for reorganization.
Need more help? Search the Idera Customer Support Portal