var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Delete/Insert/ Process Help
I have a process that gets an input file that is 700k
I have a hist table that is 2 mill
I need to append the input file to the hist table
and update any similar based on key records.
I am doing the following
Import File into input table (no indexing)
Delete from Hist table where exists (index on Hist table)
Insert into Hist table all records.
Can someone suggest a different approch or is this the best way to do this.
I don't want to delete if I don't have to
I don't want to update
Any insight would be appreciated
I am thinking of creatating a temp table to hold the output of a select statement, Truncate hist table then insert all into hist table.
Last edited by rbackmann; 10-10-05 at 10:51.
Look up the MERGE command in the SQL reference manual as that can do insert or update. Dont know if it will be quicker but give it a go.