SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK USING ORACLE SQL STORED OUTLINES AND OPTIMIZER PLAN STABILITY 2003
SUMMARY
-
Items Found: 30
- Introduction 1
- Setting Up for Use of Outlines 1
- Installing OUTLN Schema “After the Fact” 1
- Script to Install OUTLN Schema 2
- General Facts about OUTLN Schema 3
- Requirements for OUTLINE Use 4
- Some General Usage Notes: 5
- Views Used With OUTLINES 5
- Packages Used with OUTLINEs 6
- Plan Stability 6
- Creation of a OUTLINE object 7
- Altering a OUTLINE 8
- Dropping an OUTLINE 9
- Use of the OUTLN_PKG To Manage SQL Stored Outlines 9
- DROP_UNUSED 9
- DROP_BY_CAT 11
- UPDATE_BY_CAT 12
- New Procedures for Oracle9i 13
- Manually Editing Plans 14
- Using DML and Packages to Edit Outlines 15
- A Detailed Example 15
- Using DBMS_OUTLN_EDIT. GENERATE_SIGNATURE 20
- Replacing a Non-Hinted Outline 21
- Technique 22
- Example 22
- Moving OUTLINES from One DB to Another 24
- Scenario 24
- Technique 25
- Example 26
- Summary 28
