Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 31 Jan 2014 @ 21:19:59 GMT


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


Subj:   V14.10 -- Optimizer statistics usage
 
From:   Gregg, William

Hi - In the Release Summary for v14.10, in the section entitled Automated Statistics Management, the following bullet point occurs:

DBQL logging options that record Optimizer statistics usage and recommendations.

Has anyone on v14.10 investigated the type of feedback available about Optimizer decision making with respect stats and their usage?

Has anyone had success identifying "useless' stats (particularly the multi-column variety) that may be dropped?

Anything that may be shared?

In our shop, stats collection and the decisions around stats to collect are performed by DBAs or their fairly vanilla processes.


Thanks,

Bill Gregg



     
  <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