SQL Coding Best Practises

Date: 
Sunday, 26 June, 2005 - 14:30 - 15:30
Speaker: 
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

 

sqladria

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

facebook
linkid
twitter

 

Events in 2024

VODICE -  10th - 13th June 2024