Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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


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

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