IT-eBooks.directory Facebook Icon Image IT-eBooks.directory Google Plus Icon Image IT-eBooks.directory Twitter Icon Image
IT-eBooks.directory Logo Image

Using Oracle Sql Stored Outlines & Optimizer Plan Stability

Using Oracle Sql Stored Outlines & Optimizer Plan Stability Image

Book details:

Publisher:Rampant
Categories: Rampant , Using
Author:
Edition:1
ISBN-10:0974071684
ISBN-13:9780974071688
Pages:36
Published:
Posted:Jun 30 2016
Language:English
Book format:PDF
Book size:0.58 MB

Book Description:

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.

Download Link:

IT-eBooks.directory