REBUILD—Reconstruct Indexes

The REBUILD keyword reconstructs the indexes in a database or tablespace.
cafrdb2
The REBUILD keyword reconstructs the indexes in a database or tablespace.
Review the following considerations:
  • The DATABASE option is not valid for directory or catalog objects.
  • You can use wildcards to specify index names.
  • If you specify more than one index for REBUILD INDEX, separate the names with commas.
For the syntax of this keyword, see RECOVER and REBUILD.