Archives of the TeradataForum
Message Posted: Mon, 26 Sep 2005 @ 10:17:22 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|