title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
DB2 Visual Explain for SQL Application Performance Analysis
Duration
1 Day
Course
DBDB-370
Available Formats
Classroom Training
Course Description
Overview
This course provides students a brief overview of DB2 SQL performance considerations, including establishing goals for Application SQL performance. Students explore the capabilities of Visual Explain that are beyond those of the Explain Plan SQL statement – Filter Factor analysis, Stage1 and Stage2 analysis, number of rows returned.The Visual Explain performance analysis capabilities are used to explore several SQL statements to illustrate the major DB2 data accesses - Table Space scans, Non-Matching and Matching Index scans, Index only access, and understanding sort impact. Extensive, guided workshop sessions give additional insights into performance analysis using Visual Explain. One workshop improves the performance of SQL statements via rewriting them.
Objectives
Upon completion of the course, students will be able to:
- Examine Application performance goals
- Explain the additional capabilities of Visual Explain that are beyond those of the Explain Plan SQL statement – Filter Factor analysis, Stage1 and Stage2 analysis, number of rows returned
- Discover DB2 SQL Access Paths and Filter Factors using Visual Explain
- Predict Stage 1 (early) or Stage 2 (late) using Visual Explain
- Discover if DB2 SQL access is Table Space (TS) scan, Matching Index (MIS) scan, Non-Matching Index (NMIS) access or Index Only access using Visual Explain
- Verify the validity of the number of rows returned Visual Explain
- Develop a list of Tuning Tips for DB2 SQL Developers
Audience
- Experienced Data Processing Personnel
Prerequisites
- Previous or extensive experience using DB2 SQL
Related Courses
-
Db2 12 for z/OS SQL Performance and Tuning
CV964G- Duration: 24 Hours
- Delivery Format: Classroom Training, Online Training
- Price: 2,445.00 USD
-
Db2 11.5 for LUW: SQL Workshop
CL722G- Duration: 16 Hours
- Delivery Format: Classroom Training, Online Training
- Price: 1,630.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
Exam Terms & Conditions
??exam-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.