The BUILD statement generates:
where:
Syntax Element |
Description |
DATA TABLESJOURNAL TABLESNO FALLBACK TABLES or NO FALLBACK TABLE |
Keywords specifying the type of table to build The default is NO FALLBACK TABLE. Specify DATA TABLES when building fallback, nonfallback, or both types of tables from all AMPs. This option normally follows the restore of a cluster archive. Specify NO FALLBACK TABLE only when building indexes for non-fallback tables. |
(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 The delimiting database names need not identify actual databases. Database DBC is not included as part of a range. |
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 |