![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Wed, 30 Mar 2000 @ 00:02:33 GMT
Subj: | | Re: Re-designing Tables |
|
From: | | Richard K. Sumner |
Barbara,
To amplify what Mark has sent you. There are secondary performance gains to consider in the choice of the primary index according to how
you most often join the tables for reporting or queries. If you can select a like value for a primary index for two tables that you join
frequently so that the records from each table hash to the same amp block (clustering your data) you will avoid at least one row
redistribution during query. With tables as large as you have mentioned, this can vastly improve system performance.
Regards,
Rick Sumner
| |