Re: Ignore histograms on sql level
From: Moustafa Ahmed <moustafa_dba_at_hotmail.com>
Date: Tue, 19 Jan 2021 19:57:09 +0000
Message-ID: <BN6PR06MB2785AD37EEA69C335228BBF3E1A39_at_BN6PR06MB2785.namprd06.prod.outlook.com>
Date: Tue, 19 Jan 2021 19:57:09 +0000
Message-ID: <BN6PR06MB2785AD37EEA69C335228BBF3E1A39_at_BN6PR06MB2785.namprd06.prod.outlook.com>
That would be amazing to find out Jonathan!!
On Jan 19, 2021, at 2:48 PM, Jonathan Lewis <jlewisoracle_at_gmail.com> wrote:
I'm just wondering whether some form of the column_stats() hint could override the use of the histogram.
Regards
On Tue, 19 Jan 2021 at 06:25, Tanel Poder <tanel_at_tanelpoder.com<mailto: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:
Jonathan Lewis
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 19 2021 - 20:57:09 CET