Archives of the TeradataForum

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

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.