Archives of the TeradataForum

Message Posted: Thu, 19 Apr 2007 @ 18:56:26 GMT

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

Bill - I found the same thing. The archive space savings are found when an archived table has secondary indices. Generally the DBA does not archive the sub-table (SI) contents. When the SI data is ignored, the amount of data archived shows as a number smaller than the currentperm for the table. Often the archive storage system will compress the data when (eg. TSM) options are set to do that, but that is not part of the ARCMAIN processing.

A word to the wise: those secondary indices make their presence felt when recoveries are required.

Bill Gregg
Teradata Team
Thomson Healthcare

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