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