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