SQL$HELP72.HLB  —  CREATE  INDEX  Arguments  BUILD_ALL_PARTITIONS
    This clause operates on an index in build-pending state (created
    using MAINTENANCE IS ENABLED DEFERRED) and builds all incomplete
    partitions. If the index is not in build-pending state then the
    statement completes successfully with a warning.

    No other clauses may appear in the same ALTER INDEX statement.
Close Help