SQL$HELP72.HLB  —  ALTER  INDEX  Arguments  TRUNCATE PARTITION partition-name
    This clause operates on just the named index partition. The index
    is automatically set to MAINTENANCE IS ENABLED DEFERRED (that
    is, build-pending state) if it was currently ENABLED IMMEDIATE.
    Otherwise is stays in a disabled state.

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