Tag: optimizer

Bushy Join Trees in Oracle 12.2

There are multiple optimizer features introduced in the Oracle Database 12.2 Release. Bushy Join Trees is the one that I’ll be demonstrating in this post. First, I’ll create four tables with two indexes: CREATE TABLE t1 AS SELECT rownum n1,…

Read More >

The Side Effects of Drop ‘Unused’ Index

In this blog post I’ll demonstrate a scenario where dropping a potentially ‘unused’ index can have a negative influence on the optimizer’s cardinality estimation. Having columns with logical correlation and skewed data can cause difficulties for the optimizer when calculating…

Read More >

Optimizer Stew – Parsing the Ingredients to Control Execution Plans

Jared Still, Pythian Principle Consultant and Oracle ACE, explains how to keep track of the different methods used to control Oracle Optimizer execution plans.

Read More >