Setting Data Block Sizes Using SQL
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 that:
|
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. |