Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - Db2 EXPLAIN

Home

distance-learning center

Computer-Device_Tethered-Distance-learning Distance-learning-Building

Professional Distance-learning

IT Training Services



MFRDB88

Db2 EXPLAIN
DURATION: 1 day

FEE: $695

PRIVATE GROUP FEE: $
Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.

AUDIENCE:

  • Programmer
  • Database Administrator
  • System Analyst
  • IT Professional
 
   

DATES:

CONTENT AND OBJECTIVES:
    1. Concepts and Features
      • Query the statistics in the database for table and catalog statistics.
      • Create the PLAN_TABLE.
      • Determine which indexes are associated with a table.
    2. Statement Usage
      • Run an EXPLAIN on a program.
      • Run an EXPLAIN on two statements provided by the instructor.
    3. Output Tables
      • Review the PLAN_TABLE to determine joins method used for the step, prefetch techniques and method used to access the table.
      • Review the STATEMENT_TABLE and determine type of query being explained, and estimated total cost in timerons.
    4. Performance Factors
      • Locate and review the principle statistics effect performance of a query.
      • Determine the access path for a query and modify the query to change the access path.
    5. Interpreting Data Access
      • Using the PLAN_TABLE, determine the performance issue with a query and repair the problem.
      • Determine how many sorts are being performed on a query and why.
      • Determine the type of join being performed; modify the query to use a different join type.

 
 
    Web-based Training   Blended Learning    
Synchronous
Instruction
Asynchronous
Instruction
 

 

Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.

SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.