Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 16 Jun 2005 @ 13:24:42 GMT


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


Subj:   Re: Check Table and un-hashed tables
 
From:   Bergman, Ysbrand

Hi,

There are some tables that are not hash distributed. These unhashed tables, are also referred to as "AMP local", meaning that the rows are either related to activity on their amp or that there is a complete set of rows on each amp. For example, the TransientJournal table has a data row on a given AMP for each active operation that impacted data on that same AMP. This organization is designed to support time critical operations necessary for DBS overhead such as lock management, rollback and recovery.

Because of the time critical nature of these tables, all redundant structures such as fallback and secondary indexes are removed. A fallout of this is that there is no way for the Checktable utility to cross check the table structure. Checktable will therefore skip any checking for these tables.


Regards,

Ysbrand



     
  <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