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 Combined Scintigraphic and Radiographic Diagnosis of Bone and Joint Diseases by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Hip Arthrodesis and Associated Problems by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book The European Central Bank at Ten by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Unternehmensmodellierung by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Desert Regions by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Friction Welding by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Mediastinal Tumors by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Altersdepression by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Speech Rhythm in Varieties of English by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book CT Colonography Atlas by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book The Architecture of Green Economic Policies by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Body Contouring by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Morphogenetic Engineering by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Heat and Mass Transfer in Porous Media by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Handbuch Historisches Mauerwerk 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