Formal SQL Tuning for Oracle Databases

Practical Efficiency - Efficient Practice

Business & Finance, Industries & Professions, Information Management, Nonfiction, Computers, Database Management, General Computing
Cover of the book Formal SQL Tuning for Oracle Databases by Leonid Nossov, Hanno Ernst, Victor Chupis, Springer Berlin Heidelberg
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Leonid Nossov, Hanno Ernst, Victor Chupis ISBN: 9783662504178
Publisher: Springer Berlin Heidelberg Publication: September 16, 2016
Imprint: Springer Language: English
Author: Leonid Nossov, Hanno Ernst, Victor Chupis
ISBN: 9783662504178
Publisher: Springer Berlin Heidelberg
Publication: September 16, 2016
Imprint: Springer
Language: 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 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.

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

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.

More books from Springer Berlin Heidelberg

Cover of the book Computed Tomography by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Ärztliche Großpraxis by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Armleuchteralgen by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Synthesis of Saturated Oxygenated Heterocycles II by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Dispersion Forces II by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Volume Replacement by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Non-Centrosymmetric Superconductors by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Enterprise Governance by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Histological Typing of Tumours of the Thymus by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book On the Mathematics of Modelling, Metamodelling, Ontologies and Modelling Languages by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Security and Environment in the Mediterranean by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Phosphatidylcholine by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book “Two Butterflies on My Head...” by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Wiederholungs- und Vertiefungskurs Strafrecht by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Applied Regional Growth and Innovation Models by Leonid Nossov, Hanno Ernst, Victor Chupis
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy