ALLOWREORGINDEX
The ALLOWREORGINDEX option specifies whether server-initiated index reorganization is enabled or disabled.
The default is YES.
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