Online Access Paths eLearning
Access Paths Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
Oracle Database 11g Problem SQL Statements Oracle Optimizer

Oracle Database 11g: Problem SQL Statements & Oracle Optimizer Oracle
Oracle Database 11g helps to identify problem SQL statements using Oracle Optimizer and execution plans. This course discusses SQL statement processing and the role of the Oracle Optimizer and execution plans. It also explains how to generate and view execution plans using the DBMS_XPLAN package, the EXPLAIN PLAN command,
more...
Oracle Database 11g Problem SQL Statements Oracle Optimizer
Oracle Database 11g Indexes Access Paths and Join Operations

...Access Paths and Join Operations Oracle
Access paths are the ways in which data is retrieved from the database, and there are a number of different access paths which can be used for tables and indexes. This course explores the access paths used for tables, such as full table, rowid, and sample table scan. It also examines the access paths used for indexes, such as unique, range, full,
more...
Oracle SQL Tuning Diagnostics and Tuning Schema

...ffort. Participants will gain experience creating optimal access paths, such as partitioned views, B-tree indexes, bitmapped indexes, index clusters, and hash clusters. Participants will then be able to test the results of their tuning efforts using performance analysis tools.
L earn To:
Identify the need and areas for tuning the performance of SQL statements.
Identify tuning
more...
From Serebra Learning Corporation
Oracle SQL Tuning: Diagnostics and Tuning the Schema
This course is the first in a two-part series on SQL Statement Tuning. This course will help experienced application developers to learn a tuning methodology they can use to maximize database performance with minimal effort. Participants will gain experience creating optimal access paths such as partitioned views B-tree indexes bitmapped indexes index clusters and hash clusters. Participants will
more...
