Oracle Explain Plans: Driving Tables and Table Joins

Learn how a query’s driving table can impact Oracle performance.

Read More

Reading Oracle Explain Plans, Part 2: the RBO and the CBO

Learn how Oracle uses the rule-based optimizer (RBO) and the cost-based optimizer (CBO) to decide on an execution plan.

Read More

Reading Oracle Explain Plans, Part 1: The Basics

Learn exactly how Oracle arrives at an execution plan for both the Oracle rule-based optimizer (RBO) and the cost-based optimizer (CBO).

Read More

Understanding Oracle Explain Plans

Learn how to use the Oracle PLAN_TABLE and explain plans to guide performance tuning.

Read More

How Oracle Architecture Affects Performance Tuning

Key aspects of Oracle architecture may impact tuning efforts. Learn more.

Read More