|
|
Archives of the TeradataForum
Message Posted: Wed, 26 Jan 2012 @ 01:39:10 GMT
Subj: | | Re: Why does size of table increase in multiples of 512 bytes |
|
From: | | Walter, Todd |
A data block has one or more rows up to a max of the maximum block size for the table divided by the row size. One data block is stored in one
or more sectors, as many as are required to hold the block. A sector is not shared among data blocks. Data blocks grow by adding sectors as needed
to accommodate rows that have been added - or shrink by releasing sectors as data is deleted and a full sector becomes free.
| |