Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 12 Feb 2002 @ 13:06:51 GMT


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


Subj:   Re: Insert data into table
 
From:   Andres Del Villar

I understand that if I use MULTISET and UPI is the same that I use SET, and the performance is similar.

Well, my problem is the follow:

I had 300.000.000 of rows in a table and I load 300000 every day on it. This table is the source for another ten tables. Our load process taked 6 hours.

We had a problem with the data and we needed rebuild a month, near 9000000 of rows. The strategy was create another table, correct the data in that table, copy the original correct data on a second table and copy data of the first table to second table, rename the second table how the original table.

We did this with all our tables (11), the consecuence was that our load process taked 18 hours. For this situation we decided delete 150.000.000 of rows, but our load process take 8 hours.

I don't know what is the problem, i have recollect statistics and i can't reduce the hours. I think that the problems is produced in INSERT/SELECT instructions. The programs are the same in all the cases.

What can I do? I need to reduce the hours, six is my fist goal, less is better.


Thanks

Best Regards
Andres del Villar
DBA - FASA



     
  <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