Archives of the TeradataForum

Message Posted: Mon, 26 Sep 2005 @ 10:17:22 GMT

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

Index is usually based on better distribution of data. As the performance of any TD machine is governed by its slowest AMP. To get uniqueness NUSI are implemented. One other important consideration in PI is the most used join column, to avoid duplication/ redistribution of data during joins.

To get a better understanding about TD indexes please go through Database design(1094.pdf) in Teradata documentation.

_______________________________ Best Regards,

Rehan A. Khan, PMP
Teradata Certified Master
Program Manager, TD Development
Teradata, A Division of NCR

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