8. SQL Statements : CREATE INDEX : Parallel Index Building
 
Share this page                  
Parallel Index Building
Use parallel index to more efficiently create indexes in parallel. Each of these indexes can also be marked as persistent, which means that if the underlying base structure of the table is reorganized (or modified), the indexes are recreated automatically.
Note:  UNIQUE cannot be specified before both the INDEX keyword and with an individual index specification. If UNIQUE is used before INDEX, all the indexes being created are unique indexes. See the Examples (see page CREATE INDEX Examples) later in this section.