Archives of the TeradataForum

Message Posted: Tue, 12 Feb 2002 @ 15:56:25 GMT

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

Our tables are created using SET, NO FALLBACK, NO BEFORE JOURNAL, NO AFTER JOURNAL.

The load process use multiload for load data into a base table, app. 300.000 every day. The process verify the data, complete it and then load this data into the final table using

INSERT INTO bd1.table1
SELECT *
FROM bd2.table2
;

The two principal tables used the above process. The another nine tables using the follow process

INSERT INTO bd3.table3
SELECT *
FROM bd2.table2
WHERE column2 IS NULL
;

I have a few experience in teradata only seven month, and i don't know how are the performance considerations.

adelv

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