J. Features Introduced in Ingres II 2.5 : New SQL Functionality : Parallel Index Creation
 
Share this page                  
Parallel Index Creation
A new variation of the CREATE INDEX statement allows the user to create multiple secondary indexes with a single pass through the base table. After the required base table columns are extracted, the indexes are created in parallel, each one using an independent worker thread. For additional performance, any necessary sorting is performed using the new parallel sort capability.
The new syntax is:
CREATE INDEX (index-spec), (index-spec), ...
where an index-spec looks similar to the original CREATE INDEX statement:
(index-name ON base-table (column-list) WITH with-clause)