Re: MERGE statement not working with use of hints

"What's in a namespace" <xml_at_ns.com> wrote in message news:45795ddb$0$324$e4fe514c_at_news.xs4all.nl...
>
> "What's in a namespace" <xml_at_ns.com> schreef in bericht
> news:45793822$0$337$e4fe514c_at_news.xs4all.nl...
> >
> > "Dereck L. Dietz" <dietzdl_at_ameritech.net> schreef in bericht
> > news:pc3eh.20172$9v5.12764_at_newssvr29.news.prodigy.net...
> >> The following code has been written under Oracle 10g R2.
> >>
> >> The first merge statement
> >> will insert rows into the stg_provider table. However, if any hint at
> >> all
> >> is used
> >> nothing will be written. I have other procedures using merge
statements
> >> with hints
> >> which work just fine. Any suggestions on where I should look would be
> >> appreciated.
> >>
> >>
> >> MERGE INTO stg_provider a
> >>
> >> MERGE /*+ APPEND */ INTO stg_provider a
> >>
> >
> > From AskTom: the conclusion was:
> >
> > <quote>
> > actually, hmmm, i just tested without parallel dml and sure enough, the
> > APPEND
> > hint does in fact modify the behaviour of the MERGE, interesting --
every
> > time I
> > answer something with a test case to back it up, I goof.
> > <unquote>
> >
> > so it seems that merge and append do not go together very well.
> >
> > Shakespeare
> >
> >
> >
>
> With AskTom working again, and not reading from the Google cache I found
> this:
> <quote>
>
> Reviewer: Su Baba
>
> Can /*+ APPEND */ hint be used with MERGE?
>
>
> Followup:
> yes, the insert component of a merge can be done in append mode.
>
> <unquote>
>
> from which one may conclude that the + APPEND hint should be in the insert
> part, not in the MERGE part.
>
>

Thanks. Received on Fri Dec 08 2006 - 18:30:45 CST