optimizer – Page 2 – Learning is not a spectator sport

Statistics on Object tables

Way back in Oracle 8.0 we introduced the “Object-Relational” database, which was “the next big thing” in the database community

Just a short post today on something that came in as a question for the upcoming Office Hours session which

Here’s an interesting little oddity (aka bug) with scalar queries. We’ll start with a simple working example SQL> create table

One cool technique that the optimizer can employ is the BITMAP CONVERSION TO ROWIDS method to take advantage of B-tree

Just a quick post here so I could consolidate some information about histograms in 12c. On my last Office Hours

To protect the integrity of people’s data, and isolate sessions on LiveSQL, we lock down the environment. Clearly if you

One of the cool features in 12c is the automatic collection of optimizer statistics when a table is either created

On AskTOM episode 8, I’ve taken a look at locating the SQL Plan Directives used for a particular query. Here

Subtle variances in the way you work with statistics can have a significant impact on how your optimizer plans work

I had an interesting question on AskTom today, with a nicely provided test case !!!, so I thought I’d share