Example: Assigning tables to cache segments
To assign the table HISTORY_DATA and all of its contents to the cache segment HISTORY CACHE, use the following statements:
CREATE CACHE SEGMENT HISTORY CACHE
ALTER TABLE HISTORY_DATA ADD CACHE SEGMENT HISTORY_CACHE
See also