DB2 for i Query Optimization - Jim Denton

A critical success factor in using SQL to query data, whether it be to do some simple record look up, or a complex report, is to understand the process of query optimization. This session gives an introduction to query optimization and the DB engine. It also covers the factors that influence optimizer, the output of the optimizer and lists the tools you should be using to view feedback provided by the optimizer.

Jim Denton

Senior DB2 for i Consultant - IBM

Jim Denton is a senior DB2 for i consultant in IBM Systems Lab Services whose responsibilities include both teaching courses and "hands on" consulting. Jim specializes in SQL performance, data centric programming, and database modernization. Jim started his IBM career in 1981 and has had a variety of responsibilities including systems performance and five years designing and implementing enhancements to DB2 for i.