Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 18 Jan 2002 @ 15:37:28 GMT


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


Subj:   Re: Create Set Table ... As
 
From:   Thomas F. Stanek

Claybourne,

Keep in mind that the 'CREATE TABLE AS..' allows for multiple options. For example, the query used does not have to be a direct copy of another table. It could be a multi-join query, in which case there is no way for Teradata to determine whether set or multiset is required. In any case, the query portion really only determines the columns of the resulting table. The other parameters of a CREATE TABLE statement still need to be applied, such as set|multiset, fallback, etc.

Regarding stats, the same rules apply. Stats for the resulting table based on the source data really only apply in a situation where you are creating a table based on the exact image of an existing table.

I hope this makes some sense.

Thomas F. Stanek
TFS Consulting
www.tfsconsulting.com



     
  <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