15.00 - Row Size Calculation - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Row Size Calculation

This topic describes a procedure for calculating the physical size of a row for a typical table stored on a system with a packed64 format architecture. The procedure does not account for 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” on page 858 and “Sizing a LOB or XML Subtable” on page 861), nor does it account for spool file rows, which can be approximately 1MB long.

Use the Row Size Calculation form (see Appendix E: “Sample Worksheet Forms” to record your calculations.

The following employee table row definition is used as a sample for this procedure: