Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 14 Oct 2009 @ 09:13:32 GMT


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


Subj:   Stats not being used by optimizer
 
From:   prahlad.k.patidar

Hi guys,

We have a complex query running against Teradata 12.

When I see explain plan for this after running diagnostic helpstats on for session, it recommends certain sets of collumns for stats collection but stats for all those columns exists.

Still why is it giving these recommendation? All stats are up to date.

What could be reason, it optimizer not reading stats properly? if so then can we say stats collected on columns used by joins and where clause do not always help.

Can anyone please shed some light on this?


Regards

Prahlad Patidar
Concadia - Accenture



     
  <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: 27 Dec 2016