Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 03 Aug 2011 @ 14:20:08 GMT

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

Subj:   Re: Difference between collect stats on a column vs. a table
From:   sukul mahadik

Thank you all.

I just wanted to know if there will any performance wise difference between collecting stats on table and collecting stats on individually in sequence.

Actually we have a job in production which failed with AMP skew in a 'Collect stats' query. (which is quite rare scenario for us)

That table is having stats defined on 5 columns.

I was just wondering if replacing this statement with 5 individual query will make any performance improvement or prevent it from failing.

PLease Help.



  <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