Archives of the TeradataForum

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

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

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>>