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 Marine Ecological Geography by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Early Breast Cancer by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Quantum State Transfer and Network Engineering by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Magnetic Resonance Imaging by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Model Driven SOA by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Language Comprehension by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Non Coding RNAs in Plants by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Anthropologie by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book In-situ Thermoelectrochemistry by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Arbeit und Gesundheit im 21. Jahrhundert by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Soils of Tropical Forest Ecosystems by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Multidimensional HPLC of Polymers by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Stichproben by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Handbook of Computational Finance by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Membrane Transport Mechanism 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