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 Adenocarcinoma of the Esophagogastric Junction by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Standard-Based Data and Information Systems for Earth Observation by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Warum Hunde? by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Process Management by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Stress und Burnout in Organisationen by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Structure and Function in Normal and Abnormal Hips by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Evolutionary Biology by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Transactions on Large-Scale Data- and Knowledge-Centered Systems XVIII by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Yearbook of Intensive Care and Emergency Medicine by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Aus allen WeltteilenDie Arktis by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Laser Measurement Technology by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Essays on Economic Psychology by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Fifty Years of Quasars by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Unternehmenskultur aktiv gestalten by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Exchange and Transport of Air Pollutants over Complex Terrain and the Sea 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