SQL$HELP72.HLB  —  CREATE  STORAGE_MAP, Arguments  PARTITIONING_IS_NOT_UPDATABLE
    Specifies that the value of the partitioning key cannot be
    modified and that the row is always stored in the storage area
    based on the partitioning criteria in the STORE USING clause. The
    partitioning key is the column or list of columns specified in
    the STORE USING clause.

    Specifying the PARTITIONING IS NOT UPDATABLE clause allows Oracle
    Rdb to quickly retrieve data because the partitioning criteria
    can be used when optimizing the query.

    To update columns that are partitioning keys in a NOT UPDATABLE
    storage map, you must delete the rows and then reinsert the rows
    to ensure that they are placed in the correct location.

    If you specify the PARTITIONING clause, you must also specify the
    STORE USING clause when defining a storage map.

    If the PARTITIONING clause is not specified, UPDATABLE is the
    default.

    See the Oracle Rdb Guide to Database Design and Definition for
    more information regarding partitioning.
Close Help