15.00 - Procedure - Teradata Database

Teradata Database Design

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

Procedure

Perform the following procedure to complete the Row Size Calculation form for each table.

1 Identify each column in the table and enter its name in the Column Name column.

2 Identify the data type for each column and enter it in the Type column next to the column name.

 

IF the type is …

THEN …

predefined

use the sizing factors on the right-hand side of the form to determine the size of values stored for each data type.

BLOB, CLOB, or XML

enter 39 bytes for the value of its OID.

BLOB, CLOB, and XML values are stored outside of the row in their own subtables, which also must be accounted for in your capacity planning.

a distinct, structured, or ARRAY UDT

use the back of the form to tally its size.

When you have identified and tallied all UDT columns in the table, copy their sum into the UDTs item in the sizing factors column on the right-hand side of the form.

3 Determine the maximum value of the specified data type for each column in the table and enter the value in the Max column.

4 Compute the average size of the specified data type for each column in the table and enter the value in the Avg column.

5 Enter the total physical row size, rounded up to an even number of bytes, as Physical Size.