Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 30 Aug 2010 @ 17:09:33 GMT


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


Subj:   Re: How to Overcome product join
 
From:   Ramachandran, Janardhan

Hi ,

How much CPU and execution time has taken for the product join step ?

If the data size is more then optimizer will go for merge join by redistributing/duplication of the small table. So you don't want to worry on that.

You have to just collect the stats on the joining columns of both the tables and see the explain plan.

Check how much distinct values are there on the joining columns. Depending on that join method is decided by the optimizer.


Thanks & regards

Janardhan R



     
  <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