Contents

The Challenge with Internal Database SQL Optimizers

Statistics and Index Statistics May Not Be Up to Date

Cost Estimation May Not Be Accurate

Database Internal SQL Rewrite

How Quest SQL Optimizer Solves the SQL Problem

Changing SQL Syntax Can Improve SQL Performance

Quest Recursive SQL Transformation Technology

SQL Transformation Rules Provide Semantic Equivalence

Transformation Rules for Correcting Common Errors

Transformation Rules for Join Path Control

Why Join Paths Matter

How to Control the Join Path

Transformation Rules Relating to Index Usage

Miscellaneous Transformation Rules

What Are Optimization Hints?

How Hints Work with SQL Transformation

SQL Optimizer Forecast

Is SQL Optimization an Unsolvable Problem?

Accurate Cost Estimation Versus Plan Space

What about a Self-Learning SQL Optimizer?

What Is the Role of Quest SQL Optimizer in the Future?

About the Author

About Quest Software, Inc.

Contacting Quest Software

Contacting Quest Support

Oracle Magazine White Papers - Solving the SQL Tuning Problem Index