Online Documentation for SQL Backup for SQL Server

Rebuild options


This tab provides a number of advanced options for index reorganizing.

 

Editing Service task template - Reorganizing indices - Rebuild options

 

 

Free space

Define which pages should be reorganized: ones with the RadioButton default or RadioButton specified amount of free space per page.

 

CheckBox Pad index

Enable this option to leave the space open on each page in the intermediate levels of index.

 

CheckBox Sort results in tempdb

This option indicates that intermediate sort results used to rebuild indices will be stored in the tempdb database.

 

CheckBox Ignore duplicate keys

If the option is enabled then duplicate keys will be ignored.

 

CheckBox Keep index online while reindexing

This option determines whether concurrent user access to the underlying table or clustered index data and any associated non-clustered indexes is allowed while reindexing.