Instructor Led Explain Plan Training
Explain Plan Training Provider? - Tell us about your Training!
 online course |
 instructor-led class |
 learn at home |
 group study |
 self-directed study |
 cd-based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer-based learning |
 discount pricing |
 online tutorial |
From NobleProg - IT training courses
Oracle Database 11g Performance Tuning
...f Execution Plans
* DBMS_XPLAN Package: Overview and EXPLAIN PLAN Command
* Reading an Execution Plan, Using the V$SQL_PLAN View and Querying the AWR
* SQL*Plus AUTOTRACE and SQL Trace Facility
* How to Use the SQL Trace Facility
* Generate an Optimizer Trace
Module 9. Influencing the Optimizer
* Functions of the Query Optimizer, Selectivity, Cardinality and
more...
...f Execution Plans
* DBMS_XPLAN Package: Overview and EXPLAIN PLAN Command
* Reading an Execution Plan, Using the V$SQL_PLAN View and Querying the AWR
* SQL*Plus AUTOTRACE and SQL Trace Facility
* How to Use the SQL Trace Facility
* Generate an Optimizer Trace
Module 9. Influencing the Optimizer
* Functions of the Query Optimizer, Selectivity, Cardinality and
more...
From Wintrac Inc.
DB2 Visual Explain for SQL Application Performance Analysis
About Wintrac
Wintrac provides one stop shopping for all your IT training needs. Wintrac s course catalog of over two thousand courses includes courses on Mainframe training , COBOL Training and DB2 training
This course gives a brief overview of DB2 SQL performance considerations, including establishing goals for Application SQL performance.
We explore the capabilities of Visual Explain
more...
DB2 Concepts and Facilities
First, the concepts of DB2 are presented and discussed.
The major features of the Structured Query Language (SQL) are presented as the means to access DB2 data (and to create and secure DB2 components). Several of the "special features" of SQL are presented.
Optionally, guided, hands-on, practice sessions give each attendee an opportunity to use SQL to access data. QMF and/ or SPUFI are
more...
DB2 for z-OS Application Programming - Advanced
DB2 performance guidelines are discussed in detail. The SQL statement EXPLAIN PLAN is used to help to evaluate the efficiency of SQL statements. Advanced Programming Performance considerations are presented to "tuned" programs to perform "better" that their "untuned" counter parts.
You can get a complete list of other DB2 classes at
more...
