Buying Options
Oracle SQL Tuning Pocket Reference
Print $9.95
Add to Cart
Print+Ebook $10.95
Add to Cart
Ebook $7.99
Add to Cart
Safari Books Online
Add to Cart
What is this?
Print £7.50
Add to Cart
What is this?
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
  1. Chapter 1 Oracle SQL TuningPocket Reference

    1. Introduction

    2. The SQL Optimizers

    3. Rule-Based Optimizer Problems and Solutions

    4. Cost-Based Optimizer Problems and Solutions

    5. Problems Common to Rule and Cost with Solutions

    6. Handy SQL Tuning Tips

    7. Using SQL Hints

    8. Using DBMS_STATS to Manage Statistics

    9. Using Outlines for Consistent Execution Plans

    View Full Table of Contents
    Product Details
    Title:
    Oracle SQL Tuning Pocket Reference
    By:
    Mark Gurry
    Publisher:
    O'Reilly Media
    Formats:
    • Print
    • 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
    About the Author
    1. Mark Gurry

      As a database administrator on a financial IMS project about eight years ago, Mark Gurry was asked to investigate his company's database direction for the next five years. The number of users was up to 950, the cost of maintaining the mainframes was huge, and he'd heard about relational databases and downsizing. After much investigation, he chose Oracle, and has stuck with the system ever since. He has worked as Manager of Computing and Network Services, senior database administrator, senior Oracle technical support, and other jobs. He now has a small consulting company called New Age Consultants. Mark has worked for many large organizations and is currently working for Telecom Australia, the largest computer site in Australia and one of the largest in the world. He has also spoken on tuning at Oracle user group meetings and has given internal tuning courses at several of his larger client sites. He has been a senior team member on award-winning systems that have been developed using Oracle.

      View Mark Gurry's full profile page.

    • Book cover of Oracle SQL Tuning Pocket Reference