Re: How to pass hints without modifying SQL code

I think SQL Patch is the best way to go: https://sqlmaria.com/2020/02/25/how-to-use-a-sql-plan-baseline-or-a-sql-patch-to-add-optimizer-hints/#more-1121

[image: LORE DATA]
Franky Weber Faust

Consultor de Banco de Dados | LORE DATA
Oracle ACE ♠️
Fone: *47 99125 2714*
Email: franky_at_loredata.com.br
loredata.com.br

On Wed, Oct 6, 2021 at 11:31 AM Hameed, Amir <amir.hameed_at_sleepnumber.com> wrote:

> Hi,
>
> I am working on optimizing a SQL statement that is part of a COTS/packaged
> application and therefore, direct code modification is not an option. In
> this scenario, I am trying to find the most efficient way to pass hints
> without modifying the code.
>
>
>
> Kind regards,
>
> Amir
>

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