Re: ignore table stats

There's a hint named DYNAMIC_SAMPLING_EST_CDN([<_at_Block>] <Table>) that can be used to force the usage of dynamic sampling even when the tables have statistics.

Kind Regards,

Lucas Pimentel Lellis

On Fri, Jun 17, 2022 at 7:01 AM Michael D O'Shea/Woodward Informatics Ltd < woodwardinformatics_at_strychnine.co.uk> wrote:

> Hi Laurentiu, there is this „LEVEL 2“ (and others) documented here
> https://docs.oracle.com/en/database/oracle/oracle-database/18/tgsql/options-for-optimizer-statistics-gathering.html#GUID-DEE2AF8B-5F4B-4FE7-9F0E-7D188921EBCC that
> also might lead you down an interesting detour (it’s not a hint, but a
> session setting).
>
> Link above for 18c. Not sure what DB version you are using.
>
> Mike
>
> Woodward Informatics Ltd
> http://www.strychnine.co.uk
>
>
>
> Am 17/06/2022 um 11:44 schrieb Laurentiu Oprea <
> laurentiu.oprea06_at_gmail.com>:
>
> Hello guys,
>
> Just a stupid question: is there a way (parameter / hint) to determine the
> optimizer to ignore table stats and relay just on dynamic_sampling numbers?
>
> THanks.
>
> PS: althought the question sound stupid, what I basically want is to
> simulate a bad execution plan for a scenario in the past where some table
> stats were missing and I want to see how oracle came with some crazy join
> cardinality numbers.
>
>
>

--
http://www.freelists.org/webpage/oracle-l