Oracle 9i New & Advanced Features For Developers > Oracle 9i New & Advanced Features For Developers > Section 12: SQL Statement Tuning

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

Oracle 9i New & Advanced Features For Developers

Search

Table of Contents

Oracle 9i New & Advanced Features For Developers

Table of Contents

Section 1: Course Introduction

Section 2: Using iSQL*Plus

Section 3: Advanced SQL Language Constructs

Section 4: Retrieving DDL With DBMS_METADATA()

Section 5: Advanced DBMS_METADATA() Processing

Section 6: Processing Dependent Objects With DBMS_METADATA()

Section 7: Redefining Tables With DBMS_REDEFINITION()

Section 8: Data Warehousing Features (External Tables)

Section 9: Data Warehousing Features (Table Functions)

Section 10: Data Warehousing Features (Analytic Functions)

Section 11: Complex SQL Operations

Section 12: SQL Statement Tuning

Objectives

About Enhanced SQL Statement Tuning

FIRST_ROWS

Oracle9i SQL Tuning Hints

Cursor Peeking & Cursor Sharing

Monitoring Index Usage

Section 13: Editing Private Outlines

Section 14: Collecting System Statistics

Section 15: Flashback Query

Section 16: Workspace Manager

Section 17: Invoking External Procedures

Oracle9i New & Advanced Features For Developers Page 327 Section 12 SQL Statement Tuning O bjectives Learn About Enhanced SQL Statement Tuning Learn About FIRST_ROWS Changes Learn New SQL Tuning Hints

Download Safari Books Online apps: Apple iOS | Android

This Book

Search

Contents

Oracle 9i New & Advanced Features For De... > Section 12: SQL Statement Tuning - Pg. 327