Terry Purcell of the IBM SVL Optimization Team recorded his IDUG presentation introducing the query optimization enhancements that were delivered with DB2 10 for z/OS. Terry goes into detail of each enhancement and explains when each optimization improvement can and will be applied.
This is the second of three presentations donated to IDUG by Sheryl Larsen. This presentation is from her Tuning SQL for Performance seminar, and contains information about advanced SQL programming and performance.
This is the first of three presentations donated to IDUG by Sheryl Larsen. This presentation is from her Advanced SQL Coding seminar, and contains information about advanced SQL programming and performance.
In this article Jeff Lane presents a real life situation in which parallelism presented a performance dilemma. Do you tune for response time or reduced cost?
Performance applies to people as well as processes. DBAs need to keep on their toes, take on all sorts of responsibilities, and keep themselves current. Robert Goodman of Florida Hospital tells us how to be a highly effective DBA!