smart scan
-
One day, while browsing publicly available resources (blogs, white papers), I realized there’s a lack of easily accessible information on the following topic: How to map the cost-based optimizer (CBO) formulas and numbers to the SQL Plan for the most basic scenario — comparing index range scan access vs. full table scan. As we know,…
-
Note: this is continuation of the previous post. Now, let’s finally simulate my problem. To do that, I will force reading the table into the SGA.To remain fair, I won’t cache it entirely.Why am I considering it a “fair” approach?It’s hard to expect, after having executed your query that the entire large table, say 200GB…
-
This post contains 3 parts. Recently I witnessed an interesting case which added a headache to the application owners and the business.Namely, one of the important reports which used to run smoothly all of sudden stopped behaving.Talking numbers, something what people used to get within some seconds (up to 8) unexpectedly took close to 2…