Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016