13.10 Specifying the suppress option

The option for omitting part of the data in a table in order to reduce the data length for storage is called the suppress option.

When the suppress option is specified, only the significant digits of the table's decimal data (excluding leading zeros) and the storage data length are stored when the data is stored.

Organization of this section
(1) Effects of specifying the suppress option
(2) Criteria
(3) Specification
(4) Notes

(1) Effects of specifying the suppress option

The effects of specifying the suppress option are discussed as follows.

Improved performance

(2) Criteria

The suppress option should be specified in the following cases:

(3) Specification

To specify the suppress option, enter the SUPPRESS option in the CREATE TABLE definition SQL statement.

(4) Notes