SQL Baselines - changes in underlying table stats and query regression
Hello
We have a question on the SQL BASELINE and our database version is 19c
The question is based on the following scenario
Lets suppose that we enabled the real time capture of the baselines and then disabled it after a day or two
At this point we would have baselines for repeatable SQLs
With the capture now disabled, one of the table that had 10,000 rows is now loaded with one million rows
The baseline plan for a SQL on this table had a full table scan marked as ACCEPTED plan but now with one million rows we dont want oracle to use the BASELINE and it should use an index scan. But the question is that since we have disabled the capture of the baselines, oracle will not create a new baseline for this SQL. Correct?