Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 26 Jun 2003 @ 14:00:26 GMT

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

Subj:   Re: Create Table Efficiencies
From:   Jim Downey


Two things to keep an eye on: Distribution and redistribution.

Is your data distributed evenly across all amps? if you data lumps to one amp, one amp works while the rest sit idle. it is possible your create table is lumping your data to an amp. specify a primary index that distributes the data.

When joining tables on different primary indexes are redistributed (moved) to accomplish the join. Statistics are used by the optimizer to make sure the most efficient method is used.

I use the create table as syntax and have not had any 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: 27 Dec 2016