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@xxxxxxxxxxxxxx> 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: