Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 06 Nov 2012 @ 10:24:23 GMT


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


Subj:   Re: How to Identify UNUSED STATS on a table?
 
From:   sughesh iyyani

Hi Sravan,

As you define a new stats, always keep in mind that "NO STATS BETTER THAN BAD STATS".

If you are defining bad stats, instead of giving better performance, it may confuse the PE to take a wrong plan to execute the query. So performance will get degraded.

Resource utilization is also another problem.

Statistics wizard you can use to get the info like how effective is stats you had already defined on a table.


Thanks,

Sughesh.



     
  <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: 23 Jun 2019