Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 28 Jul 2003 @ 12:14:56 GMT


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


Subj:   Re: The size of Volatile Tables
 
From:   Aldrin, John

The problem is not the Volatile table, but your choice of Primary Index on it. If you do not specify a primary index on the create table statement it will assign the first column as the NUPI (not always the best choice).

Specify a Primary Index statement and you should have no problems.



     
  <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