17.00 - 17.05 - About Setting Data Block Sizes Using SQL - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

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.