Articles & Content
Topic: 2007 NA
Subtopic: DB2 for LUW
DATE: 2007-5-7 (11:10 AM - 12:10 PM)
SPEAKERS: David Xiang (Canadian Depository for Securities), John Piccoli (Canadian Depository for Securities, Ltd.)
When there is performance problem in a system, mostly database will be blamed. In fact, tuning a tuned system and database is not going to improve performance too much. Database administrators and developers should focus on re-write SQL statements. At the beginning, the presentation discusses static and dynamic SQL statements and how to change dynamic to static. Then it will focus on several methods that the author used to help developers re-write SQL statements to improve performance. These methods include change sub-select to join, using summary and MQT tables, build effective functions... etc. The presentaion includes a lot of examples.
EXP. LEVEL: Intermediate
Ways to write best SQL statements
Change sub-query to join
Use MQT to re-write SQL statements
Use global temporary tables to re-write SQL statements
Build fast UDF and procedures
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.