Oracle SQL Tuning Pocket Reference by Mark Gurry
来源:互联网 发布:cpa挂机软件 编辑:程序博客网 时间:2024/05/20 06:52
Oracle SQL Tuning Pocket Reference by Mark Gurry
Publisher: O'Reilly Media; Pocket edition (November 15, 2001) | ISBN-10: 0596002688 | PDF | 1 Mb | 112 pages
Publisher: O'Reilly Media; Pocket edition (November 15, 2001) | ISBN-10: 0596002688 | PDF | 1 Mb | 112 pages
One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. Poorly tuned SQL statements are one of the leading causes of substandard database performance and poor response time. SQL statements that perform poorly result in frustration for users, and can even prevent a company from serving its customers in a timely manner.
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. Mark 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, Mark provides a number of handy SQL tuning tips. He discusses the various optimizer hints, telling you when they can be used to good effect. Finally, Mark 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.
Download from Ftp2Share
- Oracle SQL Tuning Pocket Reference by Mark Gurry
- Oracle SQL Tuning Pocket Reference
- Oracle PL/SQL Language Pocket Reference
- Oracle RMAN Pocket Reference
- SQL Injection Pocket Reference
- Oracle SQL*Plus Pocket Reference (2nd Edition)
- Oracle PL/SQL Language Pocket Reference, Second Edition
- Oracle PL/SQL Language Pocket Reference, Fourth Edition (Paperback), Oct.2007.eBook-BBL
- MySQL Pocket Reference: SQL Functions and Utilities
- ORACLE PERFORMANCE SQL TUNING
- oracle sql tuning
- Oracle sql statement tuning
- Oracle SQL tuning 步骤
- Oracle SQL tuning 步骤
- ORACLE SQL Performance Tuning
- Oracle SQL tuning 步骤
- Oracle SQL Tuning知识
- Oracle SQL Tuning Advisor
- 文件下载
- 应用管理 JNDI里面加和不加java:comp/env/前缀有什么区别?
- css的一些基础的东西
- 第一次面试总结
- 按回车提交问题
- Oracle SQL Tuning Pocket Reference by Mark Gurry
- 借助HiddenText 确定CheckBoxList当前的操作类型及点击的CheckBox
- 页面自动刷新
- [ASP.NET][实例]用户控件的设计与使用
- 软件质量之路(4): 建立核心框架
- Hibernate的对象关系映射(5)
- [转载]高手戏玩c++(1)
- 用CSS构建iframe效果
- 如何不让统计或广告拖慢你的网站