《Oracle SQL Tuning Pocket Reference》是O'Reilly Media出版的圖書，作者是Mark Gurry
基本介紹
- ISBN：9780596002688
- 作者：Mark Gurry
- 出版社：O'Reilly Media
- 出版時間：2001年11月15日
- 頁數：100
- 定價：USD 9.95
- 裝幀：Paperback
內容簡介
In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark's knowledge is the result of many hard-fought tuning battles during his many years of providing Oracle tuning services to clients. Mark provides insights into the workings of the rule-based optimizer that go well beyond what the rules tell you. He also provides solutions to many co...(展開全部) In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark's knowledge is the result of many hard-fought tuning battles during his many years of providing Oracle tuning services to clients. Mark provides insights into the workings of the rule-based optimizer that go well beyond what the rules tell you. He also provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. In addition to the specific problem/solution scenarios for the optimizers, the book provides a number of SQL tuning tips. It discusses the various optimizer hints, telling you when they can be used to good effect. Finally, it discusses the use of the DBMS_STATS package to manage database statistics, and the use of outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify..
