Online Documentation for SQL Administrator for SQL Server

Setting reindex action condition

Use this step to specify fragmentation values for rebuilding and reorganizing.

If you have selected Reindex now option on the previous step then the following window appears:

Rebuild index if fragmentation more or equal to

Define the fragmentation value (%) for which to perform index rebuilding.

Reorganise index if fragmentation more or equal to

Define the fragmentation value (%) for which to perform index reorganizing.

If you have selected Create a job on the previous step then the following window appears.

Define the fragmentation values for which to perform index rebuilding and reorganizing using corresponding fields.

Sort in tempdb

Determines where the intermediate sort results, generated during index creation, are stored. When this option is checked, the sort results are stored in tempdb. When it is not checked, the sort results are stored in the filegroup or partition scheme in which the resulting index is stored.

Max degree of parallelism

This parameter sets the maximum number of processors the query processor can use to execute a single index statement. Fewer processors may be used depending on the current system workload.

LOB compaction

Check this option to compact large object data (LOBs). They are contained in the clustered index or underlying table and can be compacted when an index is reorganized. The data types image, text, ntext, varchar(max), nvarchar(max), varbinary(max), and xml are large object data types. Compacting this data can cause better disk space use.

Click the Next button to proceed to the Setting index actions and options step of the wizard (if Reindex now option was selected on the previous step), or to the Performing rebuilding/reorganizing step (if you have selected Create a job on the previous step).