solidDB Help : solidDB reference : SQL: Statements : ALTER TABLE : ALTER TABLE ... SET POOLSIZE
  
ALTER TABLE ... SET POOLSIZE
ALTER TABLE table‑name SET POOLSIZE percentage
where:
percentage is percentage of the total cache size, see CREATE CACHE SEGMENT.
Access requirements
SYS_ADMIN_ROLE role
Usage
Use the ALTER TABLE ... SET POOLSIZE statement to change the cache segment size. See also, ALTER TABLE ... ADD or DROP CACHE SEGMENT.
You must restart the server to make the cache segment size change effective immediately. If you do not restart the server, the cache segment size change is gradual.
Example
ALTER TABLE table1 SET POOLZSIZE 20;
Go up to
ALTER TABLE