Using Oracle Sql Stored Outlines & Optimizer Plan Stability

Book Details:

Publisher:	Rampant
Series:	Rampant , Using
Author:	Mike Ault
Edition:	1
ISBN-10:	0974071684
ISBN-13:	9780974071688

Pages:	36
Published:	Jan 01 2003
Posted:	Nov 19 2014
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:

Related Books:

Oracle SQL Tuning with Oracle SQLTXPLAIN

Oracle SQL Tuning with SQLTXPLAIN is a practical guide to SQL tuning the way Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. Using this simple tool you'll learn how to tune even the most complex SQL, and you'll learn to do it quickly, without the huge learning curve usually associated with tuning as a whole. Firmly based in real world problems, this book helps you reclaim system resources and avoid the most common bottleneck in overall performance, badly tuned SQL. You'll learn how the optimizer works, how to take advantage of its latest features, and when it's better to turn them off. Quickly tune any SQL statement no matter how complex. Build and tune test cases without affecting production. Use the latest tunin...

Mastering Oracle SQL and SQL*Plus

This exceptional book explains fundamentals in detail, supported by realistic examples, while most other books on the market do not properly cover such basics. If you work with relational databases you need to understand the SQL language. And you will gain full competence to define, access, and manipulate data in an Oracle database, if you do so following this book's guidance. This book is fully compliant with the latest version of the ANSI SQL standard, and fully updated for the Oracle 10g database. Furthermore, this book is based on a popular Netherlands college textbook (currently in its third edition). And author Lex de Haan is vastly experienced with the Oracle database, and has 25 years of teaching experience. de Haan is also a member of the A...

Beginning Oracle SQL

For Oracle Database 12c

3rd Edition

Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. These tools include SQL*Plus and SQL Developer. SQL*Plus is the one tool any Oracle developer or database administrator can always count on, and it is widely used in creating scripts to automate routine tasks. SQL Developer is a powerful, graphical environment for developing and debugging queries. Oracle's is possibly the most valuable dialect of SQLfrom a career standpoint. Oracle's database engine is widely used in corporate environments worldwide. It is also found in many government applications. Oracle SQL implements man...