 |
 |
Archives of the TeradataForum
Message Posted: Tue, 21 Mar 2006 @ 20:28:30 GMT
| Subj: | | Re: Primary Index on Volatile table and Global Temporary Tables |
| |
| From: | | Fred W Pluebell |
Every Teradata table, even a Volatile table, has a Primary Index defined when the table is created. The PI is used for hash distribution of the
data rows. Best practice is to always explicitly specify which columns should be included in the PI. If you don't specify, the system quietly
picks the first column alone as the Primary Index.
| |
