Formal SQL Tuning for Oracle Databases:
β Leonid Nossov, Hanno Ernst, Victor Chupis
π Library
π
2016
π Springer
π English
β¦ LIBER β¦
π
Formal SQL Tuning for Oracle Databases: Practical Efficiency - Efficient Practice
β Scribed by Leonid Nossov, Hanno Ernst, Victor Chupis (auth.)
- Publisher
- Springer-Verlag Berlin Heidelberg
- Year
- 2016
- Tongue
- English
- Leaves
- 121
- Edition
- 1
- Category
- Library
β¬ Acquire This Volume
No coin nor oath required. For personal study only.
β¦ Synopsis
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....Pages i-xvi
Introduction....Pages 1-3
Some Thoughts on the Term βSQL Tuningβ....Pages 5-10
Minimum Minimorum on the Subject of the βExecution Planβ....Pages 11-23
Approaches to Formal SQL Tuning....Pages 25-29
Bottlenecks in the Execution Plan....Pages 31-71
Procedure of Formal SQL Tuning....Pages 73-78
Practical Experience with Formal SQL Tuning....Pages 79-92
Closing Remarks....Pages 93-95
Back Matter....Pages 97-109
β¦ Subjects
Database Management;Management of Computing and Information Systems;Computer Appl. in Administrative Data Processing
π SIMILAR VOLUMES
Formal SQL Tuning for Oracle Databases
β Leonid Nossov, Hanno Ernst, Victor Chupis
π Library
π
2016
π Springer
π English
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 espec
Practical Oracle SQL: Mastering the Full
β Kim Berg Hansen
π Library
π
2020
π APress
π English
Write powerful queries using as much of the feature-rich Oracle SQL language as possible, progressing beyond the simple queries of basic SQL as standardized in SQL-92. Both standard SQL and Oracle's own extensions to the language have progressed far over the decades in terms of how much you can wor
Practical Oracle SQL: Mastering the Full
β Kim Berg Hansen
π Library
π
2020
π Apress
π English
<span>Write powerful queries using as much of the feature-rich Oracle SQL language as possible, progressing beyond the simple queries of basic SQL as standardized in SQL-92.<br>Both standard SQL and Oracleβs own extensions to the language have progressed far over the decades in terms of how much you
Beginning jOOQ - Learn to Write Efficien
β Tayo Koleoso
π Library
π
2022
π Apress
π English
Learn to use the jOOQ library to manage SQL database operations in Java and JVM applications. This book walks you through what JOOQ is, how to install and get started with it, and then gets you working with it. ------------------- Practical examples and case studies demonstrate how jOOQ offers
Beginning jOOQ: Learn to Write Efficient
β Tayo Koleoso
π Library
π
2021
π Apress
π English