12.11 Specifying the no-split option

If any of the data types below is defined for a table and the actual data length of that data type is 256 bytes or greater, the system stores a row of data in multiple pages. The figure following the list shows the data storage method used to do this.

Explanation:
The variable-length character string data is stored in a page separate from the remaining data, adversely affecting the data storage efficiency. In these cases, use the no-split option to improve the data storage efficiency.
Organization of this section
(1) Criteria
(2) Specification
(3) Notes

(1) Criteria

If you specify the no-split option, the system stores one row of actual variable-length character string data in one page, even if the data length is 256 bytes or greater. The following figure shows the data storage method used when the no-split option is specified.

Figure 12-22 Data storage method used when the no-split option is specified

[Figure]

Explanation:
An entire row of data is stored in the same page. Therefore, the data storage efficiency is better than when the no-split option is not specified.

(2) Specification

To specify the no-split option, specify the NO SPLIT option in the ALTER TABLE, CREATE TABLE, or CREATE TYPE SQL definition statement.

(3) Notes