Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 20 Jul 2001 @ 14:03:33 GMT

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

Subj:   Re: Any way to speed up collect statistics
From:   Geoffrey Rommel

  I have a table that is over 300 gig and will eventually grow to a max of approx 600-700 gig. Collecting statistics is taking over 15 hours. Anything I can do to speed this up?  

Whoa! This sounds a bit too long to me. We have a table of about 400GB that we can collect stats on in 2-3 hours. (Our system is 15 nodes, 240 AMPs.)

Are you trying to collect stats on every column? If so, DON'T! Collect them on the primary and secondary indexes and *possibly* one or two other columns that are frequently used in joins. Drop any others.

W. Geoffrey Rommel

  <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: 27 Dec 2016