Formal SQL Tuning for Oracle Databases:
β Leonid Nossov, Hanno Ernst, Victor Chupis
π Library
π
2016
π Springer
π English
β¦ LIBER β¦
π
Formal SQL Tuning for Oracle Databases
β Scribed by Leonid Nossov, Hanno Ernst, Victor Chupis
- Publisher
- Springer
- Year
- 2016
- Tongue
- English
- Leaves
- 121
- Category
- Library
β¬ Acquire This Volume
No coin nor oath required. For personal study only.
β¦ Synopsis
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.
π SIMILAR VOLUMES
Formal SQL Tuning for Oracle Databases:
β Leonid Nossov, Hanno Ernst, Victor Chupis (auth.)
π Library
π
2016
π Springer-Verlag Berlin Heidelberg
π English
<p>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 espec
Beginning Oracle SQL: for Oracle Databas
β Gorman, Tim;Jorgensen, Inger;Cafffrey, Melanie
π Library
π
2014
π Apress
π English
<em>Beginning Oracle SQL</em>is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. These tools include SQL*Plus and SQL Developer. SQL*Plus is the one tool any Oracle developer or database administrator can always count on, and it is widely used i
Beginning Oracle SQL for Oracle Databas
β Lex deHaan,
π Library
π
2014
π APRESS
π English
Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. These tools include SQL*Plus and SQL Developer. SQL*Plus is the one tool any Oracle developer or database administrator can always count on, and it is widely used in creati
Oracle SQL tuning with Oracle SQLTXPLAIN
β Charalambides, Stelios
π Library
π
2017
π Apress
π English
Learn through this practical guide to SQL tuning how Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. This new edition has been expanded to include AWR, Oracle 12c Statistics, interpretation of SQL Monitor reports, Parallel execution, and Exadata-related features. Read
Oracle SQL Tuning with Oracle SQLTXPLAIN
β Stelios Charalambides (auth.)
π Library
π
2017
π Apress
π English