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 Nicht hackbare Rechner und nicht brechbare Kryptographie by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Agents and Data Mining Interaction 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 SAP on the Cloud by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Mineralocorticoids and Hypertension by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Mikroökonomik für Bachelorstudenten by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Wind Energy Meteorology by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Practice of Intramedullary Locked Nails by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Proceedings of the 2015 Chinese Intelligent Automation Conference by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Körperpsychotherapie by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Autoimmune Thyroiditis by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Magnetic Characterization Techniques for Nanomaterials by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Environments at Risk by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Fundamental Physics in Particle Traps by Leonid Nossov, Hanno Ernst, Victor Chupis
Cover of the book Häufige Hautkrankheiten im Kindesalter 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