E-Book Overview
I didn't notice that this pocket reference was still in its first printing, from January of 2002. As such most of the content is now obsolete. Specifically the author devotes a lot of space to comparing the Rule-Based and Cost-Based Optimizers, and points out the clear superiority of the latter. This was big news when Oracle 9i was about to be released, not so much now. As to the rest, there are 22 pages (out of merely 102) enumerating the many hints one can apply to SQL. There's not much here that isn't already available from Oracle documentation directly.
E-Book Content
Oracle SQL Tuning Pocket Reference By Mark Gurry
Publisher : O'Reilly Pub Date : January 2002 ISBN : 0-596-00268-8 •
Table
of
Pages : 108
Contents
• Index • Reviews •
Reader Reviews
• Errata
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
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