Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    1

    Unanswered: Merge slow as a dog

    hey guys running this merge on a table, the source table has been loaded through SQLLoader and we were hoping to kick off some update and insert triggers on the target table to identify changes for processing. Unfortunately the merge runs extremely slow, any ideas?

    MERGE /*+ INDEX(abst absturbomaster_pk)*/INTO absturbomaster abst
    USING ( SELECT * FROM absloader ) abss
    ON ( abst.dn = abss.dn )
    WHEN MATCHED THEN
    UPDATE
    SET abst.rfc822Mailbox = abss.rfc822Mailbox
    , abst.cn = abss.cn
    , abst.surname = abss.surname
    , abst.l = abss.l
    , abst.mhsORAddresses = abss.mhsORAddresses
    , abst.givenName = abss.givenName
    WHEN NOT MATCHED THEN
    INSERT
    ( abst.rfc822Mailbox, abst.dn, abst.cn, abst.surname, abst.l, abst.mhsORAddresses, abst.givenName )
    VALUES
    ( abss.rfc822Mailbox, abss.dn, abss.cn, abss.surname, abss.l, abss.mhsORAddresses, abss.givenName);

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Use explain plan or trace to see how it is processing the merge.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •