16.10 - About Setting Data Block Sizes Using SQL - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
Release Date
April 2018
Content Type
Publication ID
English (United States)

Set data block sizes for tables using the CREATE TABLE or ALTER TABLE statement. The DATABLOCKSIZE = n [BYTES/KBYTES/ KILOBYTES] specification allows you to define n as the maximum multi-row data block size used for storing rows of this table.

Teradata recommends the following:

IF... THEN...
most queries to a table access a single row of data define smaller data blocks for the table to enhance row retrieval efficiency.
most queries to the table access data across the entire table define larger data blocks for the table to reduce the number of I/Os required to read the table.