solidDB Help : solidDB reference : SQL: Statements : ALTER TABLE : ALTER TABLE ... SET COMPRESSED or NONCOMPRESSED
  
ALTER TABLE ... SET COMPRESSED or NONCOMPRESSED
ALTER TABLE table‑name SET {COMPRESSED | NONCOMPRESSED}
Access requirements
Database user
Usage
Use the ALTER TABLE ... SET COMPRESSED or SET NONCOMPRESSED statement to enable or disable compression on the specified table:
Only disk-based tables can be compressed. If you attempt to compress or decompress an in-memory table, the following error message is generated: SOLID Table Error 13100: Illegal table mode combination
Parameters, clauses, keywords, and variables
▪ COMPRESSED: Activates the compression for the specified table. If the compression is activated, the B+ tree nodes are compressed during node splits that take place in the subsequent use of the table. The statement does not instantly compress a large uncompressed table, see Compressing or decompressing an existing database.
▪ NONCOMPRESSED: Deactivates the compression for the specified table. If the compression is deactivated, the compressed B+ tree nodes are decompressed during the node splits that take place in subsequent use of the table. The statement does not instantly decompress a large compressed table, see Compressing or decompressing an existing database.
Example
ALTER TABLE table1 SET COMPRESSED
Go up to
ALTER TABLE