Re: merge into an empty table

From: <>
Date: Tue, 29 Jul 2008 11:45:14 -0500
Message-ID: <>

No, that table is not partitioned. But I will tell them to populate it via an insert rather than a merge.

thank you

Gene Gurevich

             <roman.podshivalo                                          To 
             07/29/2008 11:17              
             AM                                                    Subject 
                                       Re: merge into an empty table       

If your empty fact table is partitioned you can try to exchange partition. That could be the fastest way of populating it.

PS: As of talking developers into changing the ETL code it's not always easy especially in SOX environment 8-(


On 7/29/08, <> wrote:   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


-- Received on Tue Jul 29 2008 - 11:45:14 CDT

Original text of this message