Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 16 Nov 2012 @ 09:25:16 GMT

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

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

Hi all,

Could you please help me to understand more on performance tuning.

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, will this affects the performance of my query(queries)?

None of the stats are stale, but the stats are existing on many columns.

Ignoring the cost to collect stats.



  <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: 15 Jun 2023