Archives of the TeradataForum
Message Posted: Wed, 29 Mar 2000 @ 17:47:16 GMT
| Subj: || || Re: Re-designing Tables |
| From: || || Mark Andrews |
The primary key only comes into play if you have referential integrity turned on. Beyond that, the primary index determines how evenly
your data is distributed across the amps based on uniqueness. The best performance is from a unique primary index. All the data is
distributed evenly acroos the amps, so all amps are working evenly to return rows selected using the primary index.