Formal SQL Tuning for Oracle Databases: Practical Efficiency - Efficient Practice
暫譯: Oracle 資料庫的正式 SQL 調優：實用效率 - 高效實踐
Leonid Nossov, Hanno Ernst, Victor Chupis
商品描述
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.
商品描述(中文翻譯)
SQL 調優的目標是改善現有的執行計劃。作者討論了如何消除執行計劃中的「剎車」。這些「剎車」或瓶頸可以通過對執行計劃的正式分析來識別。為此不需要數據模型的知識。這對於資料庫管理員特別有利，因為他們通常對數據模型不熟悉或了解不足。本書以這種方法提供了許多實用的範例。
