optimizer – Learning is not a spectator sport

SQL engine and PL/SQL functions

A common pattern I see in database code is the use of a PL/SQL package to hold constants to be

No topic quite gets emotions rolling as much as the Oracle Query Optimizer. The fact that a piece of software

An AskTom customer asked the question recently: “We often use the SQL_ID to dig into the performance views once we

Just a quick tip today on doing a “reset” on your optimizer environment. SQL Plan Baselines are an awesome tool

Frequency histograms in any version of Oracle are pretty cool things, so whenever you have a distribution of data that

I did a set of articles for Oracle Magazine on a more holistic view of SQL tuning. What do I

I stumbled upon this post by optimizer guru Nigel Bayliss last week, so please have a read of that first

There is an odd contradiction that we all encounter for most databases, especially if they are predominantly used during the

One of the talks I gave recently on the Groundbreaker Yatra tour was on the changes that arrive with the

In a perfect world, the optimizer would reach out from the server room, say to us: “Hey, lets grab a