5.2.7 Fixing the row length (FIX specification) [Row store table]
When defining a table as a row store table, consider whether to define the row store table as a FIX table. When defining a table as a column store table, you cannot define that column store table as a FIX table.
A table in which every row contains fixed length data is called a FIX table.
Specifying the FIX option for a table containing only fixed-length data, and containing no null values, improves performance. Compared to tables for which the FIX option is not specified, the physical row length becomes 2 bytes shorter per column. Therefore, you can reduce the amount of disk space required when the table contains a large number of columns.
You can define a table as a FIX table by specifying the FIX option in the CREATE TABLE statement. You can specify the FIX option only if both of the following conditions are satisfied:
-
There are no columns that contain null values.
-
There are no variable-length columns.