Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 27 Jul 2012 @ 14:08:19 GMT


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


Subj:   Re: PE plan for join
 
From:   Dave Wellman

Hi Sughesh,

From the information that you've given there is no way to answer the question.

What type of join criteria are being used (equality, inequality, between)?

Is there any selection criteria applied to either table?

What are the PI's of the two tables?

Are there statistics collected on the selection and/or join columns?


Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)



     
  <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: 28 Jun 2020