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 60 Excellent Inventions in Metal Forming by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Toward Balanced Growth with Economic Agglomeration by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Applied Multivariate Statistical Analysis by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Openness, Economic Growth and Regional Disparities by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Selling Tourism Services at a Distance by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Mixtures and Mineral Reactions by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Advances in Photocatalytic Disinfection by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Clinical Acupuncture by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Clinical Target Volumes in Conformal and Intensity Modulated Radiation Therapy by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Amorphous Silicon / Crystalline Silicon Heterojunction Solar Cells by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Fertility of Immigrants by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Degeneration and Regeneration in Neurons of the Cerebellum by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Lebensbalance im Alter by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book EU Competition and State Aid Rules by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Business Project Management and Marketing 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