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