Archives of the TeradataForum
Message Posted: Thu, 06 Sep 2007 @ 17:41:47 GMT
Subj: | | Re: Data storage patterns under Fastload (and |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Thursday, September 06, 2007 11:30 -->
At initial load into an empty table the rows will be concentrated into a minimum number of maximum size data blocks. That's true even if you
specify FREESPACE percent, which could be viewed as space BETWEEN blocks (actually free sectors at the end of a logical cylinder).
Each data block always holds rows from a single table.
|