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

Oracle Magazine White Papers - Solving the SQL Tuning Problem - (Page Cover)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - (Page IFC)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page i)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 1)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 2)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 3)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 4)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 5)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 6)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 7)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 8)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 9)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 10)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 11)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 12)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 13)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 14)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 15)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 16)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 17)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 18)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 19)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 20)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 21)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 22)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 23)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 24)

Oracle Magazine White Papers - Solving the SQL Tuning Problem - Contents (Page 25)

Digital edition of Oracle Magazine White Papers - Solving the SQL Tuning Problem provided by Texterity, Inc.