[mickgas]

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);

[andrewst]

Use explain plan or trace to see how it is processing the merge.