Re: Hint is not used in SQL
From: Timur Akhmadeev <timur.akhmadeev_at_gmail.com>
Date: Thu, 16 Nov 2023 12:18:14 +0300
Message-ID: <CACGsLCL4_SCkKsCz4wA0+7zoD7Y0axbtXgpY=z0t=qdNr=q5HA_at_mail.gmail.com>
Date: Thu, 16 Nov 2023 12:18:14 +0300
Message-ID: <CACGsLCL4_SCkKsCz4wA0+7zoD7Y0axbtXgpY=z0t=qdNr=q5HA_at_mail.gmail.com>
Hi,
I've the following plan in my ebs db: https://pastebin.com/raw/2z3Kh7sj
Can you try using all the hints from the outline and see how the plan in
your db looks like?
On Wed, Nov 15, 2023 at 1:52 AM Amit Saroha <eramitsaroha_at_gmail.com> wrote:
> Hi All,
>
> I have included a tiny update statement and plan in which I am attempting
> to include two hints; unfortunately, no matter what I try, the hints are
> never used.
>
> Please have a look and let me know what I'm missing and why hints aren't
> being used.
>
> Thank you in advance for all of your feedback.
>
> Best Regards,
> AMIT
>
--
Regards
Timur Akhmadeev
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 16 2023 - 10:18:14 CET