Re: Ignore histograms on sql level
From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Tue, 19 Jan 2021 21:33:19 -0500
Message-ID: <CAMHX9JJJh=XO9zfmJd1aM23uiTrG+-QFPgM7-N2L16VC_D+F0w_at_mail.gmail.com>
Date: Tue, 19 Jan 2021 21:33:19 -0500
Message-ID: <CAMHX9JJJh=XO9zfmJd1aM23uiTrG+-QFPgM7-N2L16VC_D+F0w_at_mail.gmail.com>
Cool,
So with COLUMN_STATS you could use a SQL Patch to precisely disable
histogram use for just one column of a single table in a single query.
--
Tanel Poder
https://tanelpoder.com/events
On Tue, Jan 19, 2021 at 5:27 PM Sayan Malakshinov <xt.and.r_at_gmail.com>
wrote:
> Hi listers,
>
> Jonathan is absolutely correct as always - we can easily get it using the
> following format:
> column_stats("OWNER"."TABLE", "COLUMN", scale, length=NN distinct=NN
> nulls=NN min=NN max=NN)
>
> Simple example:
> // Full example:
> https://gist.github.com/xtender/fc3882af2ba3801935bdff2f3c17e567
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 20 2021 - 03:33:19 CET