Instructor Led Access Path Training
Access Path Training Provider? - Tell us about your Training!
From NobleProg - IT training courses
Oracle Database 11g Performance Tuning





... the Optimizer Approach
* Optimizing SQL Statements, Access Paths and Choosing an Access Path
* Join and Sort Operations
* How the Query Optimizer Chooses Execution Plans for Joins
* Reducing the Cost
Module 10. Using SQL Performance Analyzer
* Real Application Testing
* SQL Performance Analyzer: Process and Capturing the SQL Workload
* Creating a SQL
more...
From Wintrac Inc.
VSAM and IDCAMS
The course covers, in detail, all aspects of using VSAM and IDCAMS that are important to the senior application COBOL programmer in new system development or maintenance. The class lab is designed to provide an in-depth work experience.
The structure of VSAM will be discussed. Each of the three VSAM file types (KSDS, ESDS, RRDS) will be reviewed in detail showing the design and efficiency
more...
DB2 for z-OS Application Performance Tuning
Review overall DB2 SQL Performance Considerations.
Discuss the "behavior" of the DB2 Optimizer.
Explore DB2 SQL performance issues as revealed by using the EXPLAIN feature.
The major columns PLAN_TABLE and DSN_STATEMNT_TABLE are analyzed in detail. The results of the DB2 EXPLAIN process are reviewed to obtain insights into the Way(s) that the Optimizer chooses the access path to access
more...
