Articles & Content

Archives

Top 25 Tuning Tips for DB2 SQL Application Developers (Part 1) (E08)

Topic: 2010 EMEA

Subtopic: DB2 for z/OS



DATE: 2010-11-10 (08:30 - 09:30)
SPEAKERS: Tony Andrews (Themis Inc.)

There are many things developers can check and do in order to get their query, program, or application to perform better. What is noticeable in the industry is that most do not know where to start, what to check, or what to do in order to tune. This presentation provides the top 25 tips specific to the development of SQL queries and application code that directly affects performance. It will also provide them the top 10 steps to tuning a query or program. Developers will leave this presentation with a better understanding of what causes most performance issues, along with SQL standards and guidelines they can take with them for their IT shop. Some of the tips are specific to both V8 and V9 enhancements.

EXP. LEVEL: Advanced

OBJECTIVES:

Grasp a better understanding of SQL Optimization

Grasp a better understanding of stage 1 versus stage 2 and indexable versus non indexable SQL predicates

Learn many SQL standards and guidelines specific to performance that should be implemented in every shop

Learn the top 25 application development tuning tips for any query, program, or application

Learn the top 10 steps to take when tuning a query, program, or application



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.