Fixed length data types CHAR and BINARY—and variable-length data types VARCHAR, VARBINARY, LONG VARCHAR, and LONG VARBINARY—are now more highly compressed, resulting in a smaller on-disk size.
This compression applies to both encrypted and non-encrypted columns in IQ base tables.
In this release, all new CHAR, VARCHAR, LONG VARCHAR, BINARY, VARBINARY or LONG VARBINARY values inserted or updated into an IQ base table are stored using enhanced compression.
If your data resides in a 15.3 or earlier database, you can recompress CHAR, VARCHAR, LONG VARCHAR, BINARY, VARBINARY or LONG VARBINARY values with enhanced compression if you rebuild their corresponding FP indexes using the sp_iqrebuildindex stored procedure, or move them to another dbspace using the ALTER TABLE … MOVE statement, or upgrade the database with the ALTER DATABASE UPGRADE statement.