Example: Assigning data ranges to cache segments

Administrator Guide : Performance tuning : Cache segment partitioning : Example: Assigning data ranges to cache segments

The table HISTORY_DATA contains a column DT of the data type DATE. To assign data that is older than seven days to the cache segment HISTORY CACHE, use the following statements:

CREATE CACHE SEGMENT HISTORY CACHE

ALTER TABLE HISTORY_DATA ADD CACHE SEGMENT HISTORY_CACHE WHERE DT OLDERTHAN 7 DAYS