Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 29 Jun 2005 @ 18:46:26 GMT

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

Subj:   Re: Teradata row distribution and hashing
From:   Diehl, Robert

Now that I have seen the original question. I have a few more comments. On you observation of the explain plans, you probably missed that a redistribution of data occurred just before the join. Data has to amp local for any join. It is not very efficient to redistribute large amounts of data.

Another possible reason is there was a secondary index or join index that covered the query with proper values or PI.


Bob Diehl

  <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