Re: HELP- Insert/Update Sloooow

If you are using Oracle 9i or later, look up the merge command, something like ...
Merge into <target_table tt > using <source_table st> on (<tt.col1 = st.col5 and tt.col2 = st.col1>)
when matched then update set <tt.colx = tt.colx + st.coly> when not matched then insert (<list of tt columns>) values (<list of st columns or expressions>) Received on Wed Jan 05 2005 - 12:01:23 CST