This topic describes a procedure for calculating the physical size of a row for a typical non-column-partitioned table stored on a system with a packed64 format architecture. The procedure does not account for the following:
- BLOB, CLOB, or XML data, which are stored in 64 KB pieces in a subtable outside the base table row (see Sizing Base Tables, LOB Subtables, XML Subtables, and Index Subtables and Sizing a LOB or XML Subtable).
- Spool rows, which can be approximately 1MB long.
Use the Row Size Calculation form (see Sample Worksheet Forms to record your calculations.
The following employee table row definition is used as a sample for this procedure:
EmpNum | SupEmpNum | DeptNum | JobCode | LName | FName | HireDate | BDate | SalAmt |
---|---|---|---|---|---|---|---|---|
PK, SA | FK | FK | FK | NN | NN | NN | NN | NN |
INTEGER | INTEGER | INTEGER | SMALLINT | CHAR(20) | VARCHAR(30) | DATE | DATE | DECIMAL(10,2) |