发帖
雷达卡
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:
本帖隐藏的内容
原版 PDF:
Formal SQL Tuning for Oracle Databases_Practical Efficiency - Efficient Practice.pdf
(8.68 MB, 需要: 15 个论坛币)
EPUB:
Formal SQL Tuning for Oracle Databases_Practical Efficiency - Efficient Practice.epub
(2.99 MB, 需要: 15 个论坛币)
PDF + EPUB 压缩包：
Formal SQL Tuning for Oracle Databases_Practical Efficiency - Efficient Practice.zip
(7.86 MB, 需要: 30 个论坛币)
本附件包括：- Formal SQL Tuning for Oracle Databases_Practical Efficiency - Efficient Practice.pdf
- Formal SQL Tuning for Oracle Databases_Practical Efficiency - Efficient Practice.epub
京公网安备 11010802022788号
