Home > DB2 UDB for LUW > Advanced SQL via DB2 EXPLAIN

Advanced SQL via DB2 EXPLAIN

Course Code:	DWUASE
Currency:	V8 & V9
Duration:	3 days
Audience:	Application Developers, Application Programmers, Production DBAs, Database Administrators and Capacity Planners.
Prerequisites:	Completion of our course DB2 SQL Essentials or at least one year of SQL experience in a Windows, UNIX or OS/2 environment.
Summary:	This course focuses on tuning advanced SQL via DB2 Explain facilities in terms of the following DB2 UDB features: Isolation levels Locking and concurrency Join optimisation Sequence and identity columns Common Table Expressions Recursive queries Grouping sets Materialized Query tables (MQTs) Index design and usage SARGable vs. non-SARGable predicates 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, using DB2 Explain facilities.
Detailed Outline

Course Schedule