Show TOC

MINIMIZE_STORAGE OptionLocate this document in the navigation structure

Minimizes use of disk space for newly created columns in SAP IQ 15 databases.

Allowed Values

ON, OFF

Default

OFF

Scope

Option can be set at the database (PUBLIC) or user level. At the database level, the value becomes the default for any new user, but has no impact on existing users. At the user level, overrides the PUBLIC value for that user only. No system privilege is required to set option for self. System privilege is required to set at database level or at user level for any user other than self.

Requires the SET ANY PUBLIC OPTION system privilege to set this option. Can be set temporary for an individual connection or for the PUBLIC role. Takes effect immediately.

Dependencies

MINIMIZE_STORAGE applies to databases running with FP_NBIT_IQ15_COMPATIBILITY='ON'. If FP_NBIT_IQ15_COMPATIBILITY='OFF', the database engine ignores this option.

Remarks

If FP_NBIT_IQ15_COMPATIBILITY='ON', MINIMIZE_STORAGE 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 role, and the specialized storage optimization does not occur for all newly created columns; when MINIMIZE_STORAGE='OFF' for the PUBLIC role but 'ON' as a temporary user option, one-byte storage is used for new columns created by that user ID.

In SAP IQ 15.x databases, setting 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. When MINIMIZE_STORAGE='ON', there is no need to specify IQ UNIQUE, except for columns with more than 65536 unique values.

When the ratio of main memory to the number of columns is large, turning MINIMIZE_STORAGE='ON' is beneficial. Otherwise, storage of new columns generally benefits by turning this option OFF.

Note

Avoid running a database when FP_NBIT_IQ15_COMPATIBILITY='ON'. All SAP IQ 15 runtime behavior is available with the SAP IQ 16.0 interface.