SQL Coding Best Practises

There are two ways to get at DB2 data - either via DB2 utilities or SQL. Badly coded SQL accounts for a large percentage of DB2 performance problems. During this presentation we will examine the different ways of getting at the same data and how to save CPU cycles and I/O!! We will also delve into some little known facts pertaining to Joins and UNIONs as well as CASE Expressions.

Bullet Points
The old favourites revisited - Stage 1, Stage 2 & Sorts
Predicate sequence – it still makes a difference!
Outer Joins, Case Expressions & UNIONs
Locking and The Impact of COMMIT
Arithmetic in Predicate Evaluation