SQL$HELP72.HLB  —  CREATE  STORAGE_MAP, Arguments  store-clause
    The storage map definition. The store-clause in a CREATE STORAGE
    MAP statement lets you specify which storage area files are used
    to store rows from the table.

    o  All rows of a table can be associated with a single storage
       area.

    o  Rows of a table can be randomly distributed among several
       storage areas.

    o  Rows of a table can be systematically distributed, or
       partitioned, among several storage areas by specifying upper
       limits on the values for a column in a particular storage
       area. This is called horizontal partitioning.

    o  Columns of a table can be partitioned among storage areas.
       This is called vertical partitioning.

    If you omit the storage map definition, the default is to store
    all the rows for a table in the default storage area. See the
    CREATE and IMPORT DATABASE statements for information on the
    default storage area.
Close Help