Written by one the world's top Oracle script developers and author of 14 best-selling Oracle books, Mike Ault targets his substantial knowledge of Oracle tuning in this concise eBook.  With decades of experience using Oracle, Mike Ault shares secrets for Oracle stored outlines and SQL optimizer plan stability.

About the Author:

Table of Contents:

 

Setting Up for Use of Outlines Installing OUTLN Schema “After the Fact” Script to Install OUTLN Schema General Facts about OUTLN Schema Requirements for OUTLINE Use Some General Usage Notes: Views Used With OUTLINES Packages Used with OUTLINEs Plan Stability Creation of a OUTLINE object Altering a OUTLINE Dropping an OUTLINE Use of the OUTLN_PKG To Manage SQL Stored Outlines DROP_UNUSED DROP_BY_CAT UPDATE_BY_CAT

New Procedures for Oracle9i Manually Editing Plans Using DML and Packages to Edit Outlines A Detailed Example Using DBMS_OUTLN_EDIT.GENERATE_SIGNATURE Replacing a Non-Hinted Outline Technique Example Moving OUTLINES from One DB to Another Scenario Technique Example