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
CREATE INDEX Examples) later in this section.