SQL$HELP72.HLB  —  CREATE  CACHE
                                   NOTE

       You cannot issue CREATE CACHE as an independent statement.
       It is a clause allowed only as part of a CREATE DATABASE or
       IMPORT statement.

       You can also create a row cache using the ADD CACHE clause
       of the ALTER DATABASE statement.

    Creates a row cache that allows frequently referenced rows
    to remain in memory even when the associated page has been
    transferred back to disk. This saves in memory usage because
    only the more recently referenced rows are cached versus caching
    the entire buffer.

    See the ALTER DATABASE statement and the CREATE DATABASE
    statement for more information regarding the row cache areas.
Additional Information: explode extract
Environment Format Arguments Examples
Close Help