Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 15 Dec 2008 @ 08:17:47 GMT


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


Subj:   Performance related issues in full statistics
 
From:   sharmistha.panda

Hie.

I am a new user in Teradata. We have a abinitio application which is a ETL tool. which loads data into teradata database. after loading a perticular table, it collects the statistics using COLLECT_STATISTICS procedure. But recently we are facing a performance issue in production. while the load part of our job has been taking approx half an hour, the statistics collection part of the job has been running for up to 9 hours. currently we are using the following statement to collect statistics.

     CALL SYSDBA.COLLECT_STATISTICS ('DATABASE/CONTAINER NAME',
             'TABLE NAME','N',' ',RETURN_MSG)

Please let me know wher to look into for this performance issue.


Thanks in advance!

Rit



     
  <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