Articles & Content

Archives

SQL on fire! (Part 2 of 2) (C05)

Topic: DB2 for LUW

Subtopic: 2006



DATE: 2006-10-3 (10:15 - 11:15)
SPEAKERS: Serge Rielau (IBM Canada)

So you think a high bufferpool hit ratio is a sign of healthy SQL and application? Think again.This presentation shows you how to get the job done with minimal CPU and I/O, the shortest transaction times, and the fewest locks. Order queue processing, pivoting, and duplicate elimination are just a few of the problems we will tackle while learning about old and new SQL features along the way.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

How to use the transitive closure of SQL to extend it's power beyond mere joins.

Attendees will learn about recursive SQL

The perhaps most powerful new SQL feature introduced in past years: SELECT FROM UPDATE/DELETE/INSERT

MERGE/UPSERT processing will be introduced

Practical scenarios such a order processing applicable to customer shops.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.