The BUILD utility statement builds indexes and referential constraints linked through an index on tables that are being loaded with a phased or stepped LOAD.
The BUILD utility can also be used to reorganize existing indexes.
The BUILD utility works only on tables in an SQL-defined database.
|
Type of BUILD |
What it does |
|---|---|
|
Complete BUILD |
Runs all four steps |
|
Stepped BUILD |
Runs one step at a time with intermediate file sorting required between each step |
Authorization
|
To |
You need this privilege |
On |
|---|---|---|
|
Build indexes and/or referential constraints on a table |
INSERT |
The indexed or referencing table |
For more information about designing indexes and referential constraints in SQL-defined databases, see the Database Design Guide.
For more information about defining indexes and referential constraints in SQL-defined databases, see the Database Administration Guide.
|
Copyright © 2014 CA.
All rights reserved.
|
|