Hint is not used in SQL

From: Amit Saroha <eramitsaroha_at_gmail.com>
Date: Tue, 14 Nov 2023 17:50:58 -0500
Message-ID: <CAG67e6ROF8PSbrku3ArDiL-_pG0KirwzPYZJE6FChpj3R21m8w_at_mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l




application/octet-stream attachment: hint_7wh1j104vstdg.sql

Received on Tue Nov 14 2023 - 23:50:58 CET

This message: [ Message body ]
Next message: Pap: "Re: Estimations are as good as it can be, what else can be done here?"
Previous message: Mark Davidson: "RMAN dup issue"
Next in thread: Timur Akhmadeev: "Re: Hint is not used in SQL"
Maybe reply: Pierre Labrousse: "RE: Hint is not used in SQL"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message