merge into an empty table
From: <genegurevich_at_discover.com>
Date: Tue, 29 Jul 2008 09:47:29 -0500
Message-ID: <OF41B37AB8.6B94A950-ON86257495.005094E1-86257495.00514D11@discover.com>
Date: Tue, 29 Jul 2008 09:47:29 -0500
Message-ID: <OF41B37AB8.6B94A950-ON86257495.005094E1-86257495.00514D11@discover.com>
Hello:
My application team is backfilling 150M rows of data from a staging table
into an empty fact table. Under normal condition the fact table will be
populated with the merge from the staging table. This is the first time
load though and there will
be no updates - only inserts. For that reason I think that it should not be
done via a merge, but rather via a straight
insert nologging. I believe it will be much faster and more efficient that
a merge (which does an outer join). Am I correct?
thank you
Gene Gurevich
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 29 2008 - 09:47:29 CDT