Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 01 Sep 2006 @ 14:16:41 GMT


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


Subj:   Collect Statistics Takes 11 Hours
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, September 01, 2006 08:11 -->

We have a cron job that collect statistics on a table with 177,486,506 rows. This collect statistics statement takes over 11 hours. If we run collecting on columns and indexes it takes 2 hours. We have collect statistics on tables that are almost as bad, but this is the worse offender. We're at the point where we are open to anything right now. Anybody have any suggestions or ideas? Thanks



     
  <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