Calculating a Typical Block Size - Teradata Database

Teradata Database Design

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

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.