5.2 Designing a table

This section explains the items that must be considered when designing a table.

Organization of this section

• 5.2.1 Flow of table design

• 5.2.2 Criteria for selecting row store tables and column store tables

• 5.2.3 Criteria for selecting single or multi-chunk tables

• 5.2.4 Points to consider in defining a multi-chunk table

• 5.2.5 Points to consider in defining an archivable multi-chunk table [Row store table]

• 5.2.6 Normalizing a table [Row store table]

• 5.2.7 Fixing the row length (FIX specification) [Row store table]

• 5.2.8 Setting a default value for a column (DEFAULT clause)

• 5.2.9 Specifying a primary key (uniqueness constraint definition) (PRIMARY KEY) [Single-chunk table]

• 5.2.10 Specifying a foreign key (FOREIGN KEY)

• 5.2.11 Allocating an unused area inside the data page (PCTFREE) [Row store table]

• 5.2.12 Branch specification for column data of variable-length data types (BRANCH) [Row store table]

To Page Top