Large Table Update/Merge problem
From: Raghu <raghuraj_dasari_at_yahoo.com>
Date: 18 Aug 2004 00:03:14 -0700
Message-ID: <45d4e55e.0408172303.e6aadec_at_posting.google.com>
I have a temprary table with 5 million rows (A) which needs to be appended with 90 million row table (B).
Date: 18 Aug 2004 00:03:14 -0700
Message-ID: <45d4e55e.0408172303.e6aadec_at_posting.google.com>
I have a temprary table with 5 million rows (A) which needs to be appended with 90 million row table (B).
60% of the rows of the 5mil rows already exist in the big table
i need to update/merge the table A data with table B Oracle version is 8.1.7
Please advice which method is the fastest. i need to do it <30 mins
Received on Wed Aug 18 2004 - 09:03:14 CEST