ALLOWREORGINDEX

The ALLOWREORGINDEX option specifies whether server-initiated index reorganization is enabled or disabled.

The default is YES.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-ALLOWREORGINDEX--+-Yes-+------------------------------------><
                    '-No--'   

Parameters

Yes
Specifies that server-initiated index reorganization is enabled.
No
Specifies that server-initiated index reorganization is disabled.

Example

Specify that server-initiated index reorganization is enabled.
allowreorgindex yes
Related tasks:
Scheduling table and index reorganization