Oracle SQL Tuning Pocket Reference
5墨值下载
•
Tabl e o f
Contents
• Index
• Reviews
•
Reader
Reviews
• Errata
Oracle SQL Tuning Pocket Reference
By Mark Gurry
Publisher : O'Reilly
Pub Date : January 2002
ISBN : 0-596-00268-8
Pages : 108
Copyright
Chapter 1. Oracle SQL TuningPocket Reference
Section 1.1. Introduction
Section 1.2. The SQL Optimizers
Section 1.3. Rule-Based Optimizer Problems and Solutions
Section 1.4. Cost-Based Optimizer Problems and Solutions
Section 1.5. Problems Common to Rule and Cost with Solutions
Section 1.6. Handy SQL Tuning Tips
Section 1.7. Using SQL Hints
Section 1.8. Using DBMS_STATS to Manage Statistics
Section 1.9. Using Outlines for Consistent Execution Plans
Index
www.allitebooks.com
Chapter 1. Oracle SQL TuningPocket Reference
Section 1.1. Introduction
Section 1.2. The SQL Optimizers
Section 1.3. Rule-Based Optimizer Problems and Solutions
Section 1.4. Cost-Based Optimizer Problems and Solutions
Section 1.5. Problems Common to Rule and Cost with Solutions
Section 1.6. Handy SQL Tuning Tips
Section 1.7. Using SQL Hints
Section 1.8. Using DBMS_STATS to Manage Statistics
Section 1.9. Using Outlines for Consistent Execution Plans
1.1 Introduction
This book is a quick-reference guide for tuning Oracle SQL. This is not a comprehensive Oracle
tuning book.
The purpose of this book is to give you some light reading material on my "real world" tuning
experiences and those of my company, Mark Gurry & Associates. We tune many large Oracle sites.
Many of those sites, such as banks, large financial institutions, stock exchanges, and electricity
markets, are incredibly sensitive to poor performance.
With more and more emphasis being placed on 24/7 operation, the pressure to make SQL perform in
production becomes even more critical. When a new SQL statement is introduced, we have to be
absolutely sure that it is going to perform. When a new index is added, we have to be certain that it
will not be used inappropriately by existing SQL statements. This book addresses these issues.
Many sites are now utilizing third-party packages such as Peoplesoft, SAP, Oracle Applications,
Siebel, Keystone, and others. Tuning SQL for these applications must be done without placing hints
www.allitebooks.com
of 90
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论