ALTER INDEX REBUILD
ALTER INDEX [schema
.]index_name
REBUILD [INITRANSinteger
] [MAXTRANSinteger
] [PCTFREEinteger
] [LOGGING | NOLOGGING] [PARALLEL ( {DEGREE {integer
| DEFAULT} | INSTANCES {integer
| DEFAULT} } ) ] [NOPARALLEL] [REVERSE | NOREVERSE ] [TABLESPACEtablespace_name
[STORAGE ( [NEXTinteger
[K | M]] [MAXEXTENTS {
integer
| UNLIMITED} ] [PCTINCREASEinteger
] [FREELISTSinteger
] [FREELIST GROUPSinteger
] ) ]
Rebuilds the index (index_name) using information from the current index. Allows you to change the physical attributes of existing indexed information.
Forces Oracle to rebuild the index using information in that index. No table accesses are required.
Changes the initial number of transaction entries allocated to each block of the index.
Changes the maximum number of transaction entries allocated to each block of the index.
Specifies the amount of free space left in each block for inserts and updates.
Specifies that the operation is to be logged to the redo logs.
Specifies that nothing is to be written to the redo logs for this operation.
Specifies the level of parallelism to be supported, based on the following parameters:
Specifies the degree of parallelism. An integer value specifies how many slave processes can be used. Specify DEFAULT to use the default value for the tablespace.
Specifies the number of instances that can be used to execute slave processes. Specify DEFAULT to use the default value specified for the tablespace.
Specifies that no parallelism is to be used.
Specifies that Oracle will store the bytes of the index key in reverse order. This is useful in situations where rows are always added in increasing order to allow the index to grow evenly rather than always at one end. It is also useful in a Parallel Server environment, allowing individual instances to insert information in different blocks, thus reducing pinging.
Specifies that Oracle will not store the bytes of the index key in reverse order.
Specifies the physical characteristics of the specified index as follows:
Specifies the size of the next extent in bytes, kilobytes, or megabytes. If the value is not a multiple of the database blocksize, it will be rounded up to a multiple of the database blocksize.
Specifies the maximum number of extents that may be allocated for this index. The default will vary according to the database blocksize. Specify UNLIMITED for unlimited expansion.
Specifies the percentage by which each extent will grow over the previous extent. The default is 50, which means that each extent will be one- and-one-half times larger than the previous extent.
Specifies the number of free lists contained in each freelist group in this index. The default is 1 and the maximum depends on the database blocksize.
Specifies the number of groups of free lists for this index. The default is 1. This parameter should be used only with the Parallel Server option running in parallel mode.