Visual Explain (VE) for DB2 z/OS SQL Tuning

Wise

Course

In Gatwick

Price on request

The best Other Database courses

See all

See all

Description

  • Type

    Course

  • Location

    Gatwick

  • Duration

    4 Days

Upon completion of this presentation, the participant should be able to exploit the DB2 Optimizer in deciding which of several SQL alternatives will provide reduced elapsed times, CPU and I/O.

Facilities

Location

Start date

Gatwick (London)
Regus Centre, First Point, Buckingham Gate, London Gatwick Airport, RH6 0NT

Start date

On request

About this course

Completion of course DB2 SQL Essentials or equivalent knowledge.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Currency:DB2 for z/OS V8Audience:Application Developers, Application Programmers, Production DBAs, Database Administrators and Capacity Planners.Prerequisites:Completion of course DB2 SQL Essentials or equivalent knowledge.Summary:After reviewing the usage and the scope and limits of SQL operations such as:
  • INNER JOINs
  • OUTER JOINs
  • UNIONs
  • CASE expressions
  • Subqueries
  • Subselects
  • Table expressions
  • Row expressions
  • Column/scalar functions
  • Date/time arithmetic
  • Cursor operations
  • Locking & concurrency
  • Index design & usage
this course focuses on using Visual Explain V8 for DB2 z/OS to optimise SQL statements in terms of elapsed, CPU and I/O times.Objectives:Upon completion of this presentation, the participant should be able to exploit the DB2 Optimizer in deciding which of several SQL alternatives will provide reduced elapsed times, CPU and I/O.Lab:About 65% hands-on, incorporating DB2 for z/OS V8 Visual Explain.

See related categories

Visual Explain (VE) for DB2 z/OS SQL Tuning

Price on request

The best Other Database courses

See all

See all