Formal SQL Tuning for Oracle Databases
Practical Efficiency - Efficient Practice

Authors: Leonid Nossov, Hanno Ernst, Victor Chupis



A very simple but very useful method of SQL tuning is described

Analysis of bottlenecks

Numerous examples facilitate to get into the subject

Enables SQL tuning by removal of brakes in the execution plans

The target of  SQL tuning is  the improvement of the existing execution plan.  The authors discuss the removal of brakes in the execution plan. Such "brakes" or bottlenecks can be recognized by a formal analysis of the execution plan. For this purpose no data model knowledge is needed. This is especially beneficial for database administrators because they are usually not or insufficiently  familiar with the data model. The book presents numerous practical examples with this method.

Table of contents

Front Matter

Introduction

Some Thoughts on the Term “SQL Tuning”

Minimum Minimorum on the Subject of the “Execution Plan”

Approaches to Formal SQL Tuning

Bottlenecks in the Execution Plan

Procedure of Formal SQL Tuning

Practical Experience with Formal SQL Tuning

Closing Remarks

Back Matter

原版 PDF + EPUB: