SQL Coding Best Practises

Sunday, 26 June, 2005 - 14:30 - 15:30
Maria Sarikos

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



SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us



Events in 2022

VODICE -  13th - 16th June 2022