Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 06 Sep 2007 @ 18:22:19 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: Data storage patterns under Fastload (and
 
From:   bob hahn

A block holds only rows for one table. Each block can have multiple rows with different rowhash values. You can control the blocksize and freespace percentage systemwide via DBS control and at a table level with create/alter table. Fastload and Multiload to an empty table respect the freespace value. Blocks will be filled as much as possible up to the freespace percentage. NUPIs will be in the same datablocks (one or more depending on the count, rowsize, blocksize, and freespace). There is a good discussion of these topics in Chapter 3 of Database Administration and Chapter 10 of Database Design. The Ferret utility can show you the datablock sizes for a table.



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023