Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 25 Feb 2004 @ 21:43:19 GMT

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

Subj:   Re: CREATE TABLE...AS and when SIs are created.
From:   Greg Bourgoin

On Wed, 25 Feb 2004 12:59:27 -0600, Fred W Pluebell wrote:

  EXPLAIN says that the index is created first and the MERGE of the data is done afterward.  

Good point. Should have gone with the explain first, and, practical experience says you are right as well. I tested this on a smaller table. The with nothing else specified, the CREATE TABLE as OLDTABLE with/with no data does the follwing (contrary to another post):

- It does keep the primary index intact, if not otherwise specified.

- It does create secondary indexes first (if not otherwise specified) and then loads the data.

Thanks for the responses everyone.

  <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: 27 Dec 2016