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

Home

distance-learning center

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.
    Virtual Classroom   Blended Learning    

↓
Synchronous
Instruction		 Asynchronous
Instruction

Effective February 27, 2012, the course dates listed on the CETi 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. CETi makes no representation regarding ownership in any of the software products that we train on.

CETi 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 CETi course and that the employer has a licensed version of the software.

Certain courses only should be taught by the source software company training company and open source purveyor.