AW: ignore table stats

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 <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 <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