Articles & Content
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
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.