Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Sat, 09 Nov 2013 @ 11:04:14 GMT


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


Subj:   Re: Statistics on multi column UPI
 
From:   Dieter Noeth

Sughesh.Sumansingh wrote:
  Table have a UPI which is composed of 5 columns.  


  Currently there is no stats on this UPI.  


  Most of queries we are expecting all these 5 columns will be used in join / where condition.  


If you actually use it as described you don't need stats as the optimizer knows about uniqueness due to the UPI.

And if you still want to collect stats you should never collect full stats, use SAMPLE instead.


Dieter



     
  <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