Articles & Content

Archives

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

Topic: 2006 EU

Subtopic: DB2 for LUW



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.



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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