Oracle8i Performance Tuning: SQL Tuning
Overview/Description
To describe how to use Oracle Optimizer for SQL tuning and to explain data access methods
Target Audience
Network administrators, database administrators
Prerequisites
Completion of the Oracle Introduction, Oracle8i Database Administration, and Oracle8i Backup and Recovery SmartCurricula
Expected Duration
5:00 Hours
Objectives:
Oracle8i Performance Tuning: SQL Tuning
To outline how to evaluate SQL statement performance and set optimization modes
To explain how to generate and manage statistics and stored outlines
To describe how indexes and index-organized tables improve data access efficiency
To outline how clusters and materialized views improve query performance
To describe the tuning requirements of OLTP, DSS, and hybrid systems
Course Number: OR855SE