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 Cut & Paste-Management und 99 andere Neuronenstürme aus Daily Dueck by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Vom Baby zum Kleinkind by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Observation of the Continental Crust through Drilling II by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Schein's Common Sense Emergency Abdominal Surgery by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Handbook of the Physics of Thin-Film Solar Cells by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Chernobyl by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Advances in CT III by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book The Danube River Basin by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Magnetic Resonance Imaging of the Bone Marrow by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Diagnostic Neuropathology by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Handbook of Environmental Isotope Geochemistry by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book The AGP System by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Advances in Spatial Data Handling by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Mathematical Modeling and Validation in Physiology by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Internetrecht im E-Commerce 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