SQL$HELP72.HLB  —  ALTER  DATABASE  Arguments  CACHE_USING
    Specifies that the named row cache is the default physical row
    cache for all storage areas in the database. All rows stored in
    each storage area are cached, regardless of whether they consist
    of table data, segemented string data, or are special rows such
    as index nodes.

    You must either add the specified cache before completing the
    ALTER DATABASE statement, or it must already exist.

    Alter the database and storage area to asign a new physical
    area row cache that overrides the database default physical area
    row cache. Only one physical area row cache is allowed for each
    storage area.

    You can have multiple row caches that contain rows for a single
    storage area by defining logical area row caches, where the row
    cache name matches the name of a table or index.

    If you do not specify the CACHE USING clause or the NO ROW CACHE
    clause, then the NO ROW CACHE clause is the default.
Close Help