ignore table stats
From: Laurentiu Oprea <laurentiu.oprea06_at_gmail.com>
Date: Fri, 17 Jun 2022 12:44:58 +0300
Message-ID: <CA+riqSWd79njFEX6b4sdije65pa879qnv=79Vsce3=8zgko2NA_at_mail.gmail.com>
Hello guys,
Date: Fri, 17 Jun 2022 12:44:58 +0300
Message-ID: <CA+riqSWd79njFEX6b4sdije65pa879qnv=79Vsce3=8zgko2NA_at_mail.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-lReceived on Fri Jun 17 2022 - 11:44:58 CEST