Books & Videos

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