SQL$HELP72.HLB  —  CREATE  STORAGE_MAP, Arguments  PLACEMENT_VIA_INDEX
    Directs the database system to store a column in a way that
    optimizes access to that column by the indicated path. Oracle Rdb
    chooses a target page for any columns being stored by rules that
    take into account the type of index named (sorted or hashed),
    the type of storage areas involved (uniform or mixed), and how
    indexes and tables are assigned to storage areas.

    For a hashed index, Oracle Rdb calculates the page containing
    the hashed index node that points to the column. If that page is
    within the same storage area in which the column will be stored,
    it is used as the target page for storing the column. If that
    page is not within the same storage area in which the column
    is to be stored, Oracle Rdb chooses a target page in the same
    relative position within the appropriate storage area (if it is a
    mixed storage area) or a page in a clump reserved for that table
    (if it is a uniform storage area).

    For a sorted index, Oracle Rdb finds the database key of the next
    lowest row to the one being stored and uses the page number in
    the database key as the target page.
Close Help