Archives of the TeradataForum
Message Posted: Thu, 06 Sep 2007 @ 16:29:19 GMT
<-- Anonymously Posted: Thursday, September 06, 2007 10:19 -->
An (empty) table is loaded via FastLoad; the table contains 10M rows; and the rows are spread evenly by a well chosen NUPI across 100 amps.
Per the manuals, rows with the same NUPI tend to be stored in the same data block.
Will the rows of the table tend to be concentrated into a minimum number of densely packed blocks?
With respect to the Fastloaded table, do the blocks tend to hold only rows of this table?
(To focus the discussion, assume that only a few of the NUPIs map to more than three rows.)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|