Articles & Content
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
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.