Articles & Content

Archives

Techniques of Re-Writing SQL Statements (G02)

Topic: DB2 for LUW

Subtopic: 2007



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

OBJECTIVES:

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.