Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 16 Nov 2012 @ 10:45:50 GMT

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

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

Hi Sravan,

If you are using collect stats unnecessarily, apart from resource usage it may confuse the PE to take a wrong plan., so that performance degraded.

So its always advisable that don't collect stats on columns other than columns frequently used and columns which is not part of PI.


Sughesh I S.

  <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: 28 Jun 2020