15.00 - Calculating a Typical Block Size - Teradata Database

Teradata Database Design

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

Calculating a Typical Block Size

Depending on how you define your tables and the boundary conditions on their rows, the maximum size in bytes for a typical block can be estimated by the following equation:

where:

 

This variable …

Specifies …

ROUNDUP

the ROUNDUP function.

MAX x

three quarters of the maximum block size in bytes.

The upper limit on this value is 255 sectors, or 130,560 bytes.

512

the rounded up sector boundary, which is the number of bytes per sector for the table.