Database Tuning (MOSC)

MOSC Banner

SQL Baselines - changes in underlying table stats and query regression

in Database Tuning (MOSC) 14 commentsAnswered ✓

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center