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