This command will create a table in compressed mode regardless of solid.ini setting. If the table is an in-memory table, the command will return an error “SOLID Table Error 13100: Illegal table mode combination”.
ALTER TABLE ... (...) SET COMPRESSED
This command will activate the compression for this table. If the compression is activated, the B+ tree nodes will be compressed in node splits taking place in subsequent use of the table. The command will not instantly compress a large uncompressed table. For in-memory tables, the command will return an error “SOLID Table Error 13100: Illegal table mode combination”.
ALTER TABLE ... (...) SET NONCOMPRESSED
This command will deactivate the compression for this table. If the compression deactivated, the compressed B+ tree nodes will be decompressed in node splits taking place in subsequent use of the table. The command will not instantly decompress a large compressed table. For in-memory tables, the command will return an error “SOLID Table Error 13100: Illegal table mode combination”.