Advanced options

This step of the wizard provides a number of advanced options for index reorganizing.

Free space

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

Pad index

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

Sort results in tempdb

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

Ignore duplicate keys

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

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.