Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Sat, 09 Nov 2013 @ 15:32:29 GMT


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


Subj:   Re: Statistics on multi column UPI
 
From:   Dave Wellman

Hi all,

A couple of suggestions on this topic.

If you're on TD14 then COLLECT SUMMARY stats on the table as well. IMHO even faster than SAMPLE and possibly just as good.

Also, the original post said that all 5 columns of the UPI were used in the join. Is the assumption here that these columns are used with an equality condition on the join? If one or more are non-equality then you're back to possibly full stats on that column (at least).

Possibly need more details of the sql involved.


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: 24 Jul 2020