Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 19 Nov 2008 @ 21:00:18 GMT


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


Subj:   Re: Stats collection on Index Column
 
From:   Ramchandran, Janardhan

  In fact I thought that collecting stats on UPI is also not required as it is always ONE AMP operation. But again, sometimes EXPLAIN shows the difference like "LOW CONFIDENCE" or "HIGH CONFIDENCE".  


This difference your getting has "LOW CONFIDENCE" or "HIGH CONFIDENCE" because you have both index and stats gather on that column, but it in performance it wont have the difference as it will go for the same hashing technique for the UPI and USI whether it have stats or not. So it not that much worth able of collecting stats on the UPI or USI.

Note:- Optimizer will give "HIGH CONFIDENCE" in the explain when it uses both the index and stats for that step.


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