Online Documentation for All SQLManager.net Products

Defining rules


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

 

Service tasks - Reorganizing indices - Defining 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.

 

CheckBox Compact large objects

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