Re: Ignore histograms on sql level
From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Tue, 19 Jan 2021 19:47:57 +0000
Message-ID: <CAGtsp8=w+CAL+3BoYJxxotOEAnvsZspmdfm1phL3VAhT__8JHA_at_mail.gmail.com>
Date: Tue, 19 Jan 2021 19:47:57 +0000
Message-ID: <CAGtsp8=w+CAL+3BoYJxxotOEAnvsZspmdfm1phL3VAhT__8JHA_at_mail.gmail.com>
I'm just wondering whether some form of the column_stats() hint could override the use of the histogram.
Regards
Jonathan Lewis
On Tue, 19 Jan 2021 at 06:25, Tanel Poder <tanel_at_tanelpoder.com> wrote:
> Hi Moustafa,
>
> If you really need to do this at SQL level, you could use *opt_param*
> hint with *_optimizer_use_histograms = false*.
>
> But it would make this query ignore all histograms, not just one on a
> specific column:
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 19 2021 - 20:47:57 CET