Description
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. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. Mark provides a number of handy SQL tuning tips, discusses the use of the DBMS_STATS package to manage database statistics, and shows you how to use outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify.
Full Description
Table of Contents
-
Chapter 1 Oracle SQL TuningPocket Reference
-
Introduction
-
The SQL Optimizers
-
Rule-Based Optimizer Problems and Solutions
-
Cost-Based Optimizer Problems and Solutions
-
Problems Common to Rule and Cost with Solutions
-
Handy SQL Tuning Tips
-
Using SQL Hints
-
Using DBMS_STATS to Manage Statistics
-
Using Outlines for Consistent Execution Plans
-
Product Details
- Title:
- Oracle SQL Tuning Pocket Reference
- By:
- Mark Gurry
- Publisher:
- O'Reilly Media
- Formats:
-
- Ebook
- Safari Books Online
- Print Release:
- January 2002
- Ebook Release:
- February 2009
- Pages:
- 112
- Print ISBN:
- 978-0-596-00268-8
- | ISBN 10:
- 0-596-00268-8
- Ebook ISBN:
- 978-0-596-10381-1
- | ISBN 10:
- 0-596-10381-6
Customer Reviews
