Hi,
Have you checked that one:
/*+ opt_param('_optimizer_use_histograms' 'false') */
Best Regards
On Thu, Mar 18, 2021 at 2:16 PM Jonathan Lewis <jlewisoracle@xxxxxxxxx>
wrote:
Adding the hint
/*+ opt_param('_fix_control','9550277:1') */
seems to work.
Regards
Jonathan Lewis
On Thu, 18 Mar 2021 at 09:49, Laurentiu Oprea <laurentiu.oprea06@xxxxxxxxx>
wrote:
Hello,
Is there a method to influence the optimizer at session / statement level
to avoid histogram (especially hybrid) usage?
Thank you.