Minimize use of disk space for newly created columns.
ON, OFF
Can be set for the PUBLIC group or for temporary use. DBA authority is required to set the option. This option takes effect immediately.
OFF
When MINIMIZE_STORAGE is ON, IQ optimizes storage for new columns by using as little as one byte of disk space per row wherever appropriate. By default this option is OFF for the PUBLIC group, and one-byte storage is used for all newly created columns; when it is OFF for the PUBLIC group but ON as a temporary user option, one-byte storage is used for new columns created by that user ID.
MINIMIZE_STORAGE=ON is equivalent to placing an IQ UNIQUE 255 clause on every new column, with the exception of certain data types that are by nature too wide for one-byte storage.
Tables with few columns benefit when MINIMIZE_STORAGE is ON. Tables with many columns generally benefit from turning this option OFF. The definition of “few” depends on the processor; for larger processors, the number can be greater than for smaller ones.
Specifying IQ UNIQUE explicitly in CREATE TABLE or ALTER TABLE ADD COLUMN overrides the MINIMIZE_STORAGE option for that column.
Chapter 5, “Working with Database Objects” in Sybase IQ System Administration Guide.
