Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 17 Jun 2001 @ 15:07:31 GMT


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


Subj:   Re: Why redistributing?
 
From:   Ken Hansen

Hi Rudel,

Although the explain identifies the number of rows, the optimiser decides to copy a table across the nodes before this is known. That decision is based on collected statistics, the index and whether the join condition in your view matches the index precisely.

Make sure you have collected statistics on the smaller tables after indexing, or creating secondary indexes which exactly match the join condition of your view.

Ken Hansen



     
  <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