Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 14 Nov 2012 @ 12:36:33 GMT


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


Subj:   Re: How to Identify UNUSED STATS on a table?
 
From:   Bodla, Sravan Kumar

Hi Tomas,

Thanks for the detailed note!

I would just like to confirm once again, that,

If my table(tables) has stats defined on almost on all the columns (say, 80-90% columns, both single column & multi column stats), I mean, on necessary columns and also may be on unwanted columns(am not sure), will this affects the performance of my query(queries)?

We are ignoring the cost to collect stats (system resources) in this case.


Thank you!

Sravan.



     
  <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