Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 21 Mar 2006 @ 20:28:30 GMT


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


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.



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023