SQL$HELP72.HLB  —  CREATE  INDEX  Arguments  LOGGING
    Syntax options:

    LOGGING |NOLOGGING The LOGGING clause specifies that index nodes
    and hash buckets be logged when written to the database. Logging
    includes writing data and management records to the recovery-unit
    journal file (.ruj) and after-image journal files (.aij). When
    the NOLOGGING clause is specified then only a small number of
    management records are logged in the recovery-unit journal file
    (.ruj) and after-image journal files (.aij). See the Usage Notes
    below for more information.

    LOGGING and NOLOGGING can be specified per storage area
    (partition) or as a default for the CREATE INDEX statement. The
    LOGGING and NOLOGGING clauses are mutually exclusive; specify
    only one. The LOGGING clause is the default.
Close Help