Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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?


Prahlad Patidar
Concadia - Accenture

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020