Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 17 Jan 2008 @ 11:14:23 GMT


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


Subj:   Diagnostic HELPSTATS Vs. Statistics Wizard
 
From:   Anomy Anom

<-- Anonymously Posted: Thu, 17 Jan 2008 11:38 -->

I have been using "diagnostic helpstats" for a while to see stats recommendation and then choosing carefully based on confidence indication. Also, I avoid multi column stats having too many columns which might only help that particular query or so and are expensive to collect compared to single (or two) column stats.

Now I would like to start using Teradata Statistics Wizard which is meant for recommending statistics. My expectation is that its way of analyzing the query and recommending the stats is different from "diagnostic helpstats" method.

Surprisingly I found no difference between stats recommended by both methods which only confirms (to me) that Statistics Wizard is internally using "diagnostic helpstats" only.

I am interested in more accurate stats recommendation which saves a whole lot of time for the developers/dbas.

Does anyone have any good experience with this tool or any other better means of arriving at accurate stats requirement.

By the way, we are on V2R6.1.1

Thanks in advance.



     
  <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