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
Join Phil as he looks at the roadmap for the Database Management tools from Computer Associates. As well as looking at the longer term vision, Phil will also look at the driving strategy and the recent achievements. If you want to know what is happening in the world of Database Management, then don't miss this session
European SQLAdria Seminar – Vodice 2024
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.
8 reasons to come Speakers Events Contact
VODICE - 10th - 13th June 2024