Defining rules

At this step of the wizard you can set index reorganization rules.

Reorganize indices if fragmentation level is above

Define the fragmentation limits. Exceeding this limits considers the indices to be reorganized.

Rebuild indices if fragmentation level is above

Define the fragmentation limits. Exceeding this limits considers the indices to be rebuilt.

Compact large objects

Enable this option to compact image, text, ntext, varchar(max), nvarchar(max), varbinary(max) and xml data.