SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK FORMAL SQL TUNING FOR ORACLE DATABASES
SUMMARY
-
Items Found: 46
- Introduction
- Aims and Target Groups
- An Overview of the Book
- Acknowledgments
- Some Thoughts on the Term SQL Tuning
- SQL Tuning: Definitions and Objectives
- SQL Tuners
- Oracle
- Developer
- Database Administrator
- Minimum Minimorum on the Subject of the Execution Plan
- Can You Read Execution Plans?
- Some Important Details
- Sections of the Execution Plan
- Optimizer Estimations and Costs
- Runtime Statistics
- Approaches to Formal SQL Tuning
- The Objective: Effective SQL Tuning
- The Principle: Elimination of Brakes in the Execution Plan
- The Method: Analysis of Runtime Statistics in the Execution Plan
- The Main Criterion: The Runtime Statistic Cardinality
- The Procedure: An Iterative Process
- The Guideline: Tuning Without Changing the SQL Statement
- Bottlenecks in the Execution Plan
- Local Problems in the Execution Plan
- A Missing Index
- A Nonselective Index
- An Index with a Large Clustering Factor
- A Sparse Index
- Nested Loop Join Instead of Hash Join and Vice Versa
- Global Problems in the Execution Plan
- Formal Rules for Changing the Table Order in a Join
- Joins with a Low Number of Hits
- Joins with a Large Hit Quantity
- Procedure of Formal SQL Tuning
- Practical Experience with Formal SQL Tuning
- Hanno’s Experience
- Statistics on Problem Categories
- A Small Synthetic Test Case in Respect of a Nonselective Index
- Practical Example
- Victor’s Experience
- The First Practical Example
- The Second Practical Example
- Closing Remarks
- Application of the Formal Principle for the Analysis of Performance Problems After an Oracle Migration
- Literature
