solidDB Help : solidDB reference : SQL: Statements : ALTER TABLE : ALTER TABLE ... ADD or DROP CACHE SEGMENT
  
ALTER TABLE ... ADD or DROP CACHE SEGMENT
ALTER TABLE table‑name
   ADD CACHE SEGMENT segment‑name [WHERE range‑specification] |
   DROP CACHE SEGMENT segment‑name
where:
range‑specification::= col-name < value |
   col-name > value |
   col-name = value |
   col-name <> value |
   col-name BETWEEN value AND value |
   col-name OLDERTHAN value DAYS |
   col-name OLDERTHAN value SECONDS |
   col-name NEWERTHAN value DAYS |
   col-name NEWERTHAN value SECONDS
Access requirements
SYS_ADMIN_ROLE role
Usage
▪ Use the ALTER TABLE ... ADD CACHE SEGMENT statement to assign a table (or a part of a table as specified by the WHERE subclause) to a cache segment.
If you use the OLDERTHAN and NEWERTHAN keywords, which specify date and time ranges, the data type for the column must be of type DATE or TIMESTAMP.
If the value cannot be converted to the column type, the operation fails.
▪ Use the ALTER TABLE ... DROP CACHE SEGMENT statement to drop a table from a cache segment.
See also, ALTER TABLE ... SET POOLSIZE
Examples
ALTER TABLE HISTORY_DATA ADD CACHE SEGMENT HISTORY_CACHE
ALTER TABLE HISTORY_DATA ADD CACHE SEGMENT HISTORY_CACHE WHERE DT OLDERTHAN 7 DAYS
Go up to
ALTER TABLE