Articles & Content


Techniques of Re-Writing SQL Statements (G02)

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!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.