where:
- DATA TABLESJOURNAL TABLESNO FALLBACK TABLES or NO FALLBACK TABLE
- Keywords specifying the type of table to build
- (dbname)
- Name of a database
- ALL
- Keyword to indicate the operation affects the named database and its descendants
- (dbname.tablename)
- Name of a non-fallback table for which indexes are built
- EXCLUDE
- Keyword to prevent indexes from being built in specified databases
- (dbname)
- Name of database excluded from the build operation
- ALL
- Keyword to indicate the operation affects the named database and its descendants
- (dbname1) TO (dbname2)
- List of alphabetically client sorted databases excluded from the build operation
- RELEASE LOCK
- Keywords to release utility locks on the specified objects when the build operation completes successfully
- ABORT
- Keyword to abort the build operation if an AMP is offline and if the object being built is either a nonfallback table or is a database that contains a nonfallback table
- SKIP JOIN INDEX
- Skip the build of join and hash indexes