Archives of the TeradataForum
Message Posted: Tue, 12 Feb 2002 @ 14:12:20 GMT
That's rather slow
How many rows/value avg/max?
How do you load:
Inserts using MultiLoad?
FastLoad + Insert/Select?
Did you copy in a multi-statement?
In BTEQ the position of the semicolon is important:
insert into target sel * from source1 where...
Both inserts will be processed as a single statement, so there's only an entry in the transient journal indicating the table was empty, no need to journal the 9000000 records. If there's an error rollback will be easy, just empty the table again.
But if you submitted
insert into target sel * from source1 where...;
The first insert is without journal, the second one is a new transaction inserting in a table with date, so all 9000000 records are journalled. Rollback will be very lengthy...
(In Queryman it's F9 vs. F5)
Looks like NO multi-statement or a lot of duplicate row checks.
If you provide more info about your system, DDL and data demographics, you'll probably get help here ;-)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|