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. |