Articles & Content

Archives

Practical SQL Performance Tuning for Developers and DBAs (E03)

Topic: 2009 EU

Subtopic: DB2 for z/OS



DATE: 2009-10-5 (16:00 - 17:00)
SPEAKERS: Kurt Struyf (Competence Partners)

This presentation is a PRACTICAL, HANDS ON way to SQL performance tuning and SQL improvement. When logically correct SQL will always return and answer, the statement might be expensive or cheap but is quite often suboptimal. This presentation will explain the ground rules to writing performing SQL and has numerous EASY-TO-FIX, REAL LIFE improvements. If you are a developer or a beginning DBA, you’ll gain an understanding to better SQL writing and tuning. If you are a more experienced DBA you’ll get a thorough refresh, learn something new and walk a way with an idea of "how to explain SQL to your developers".Following the rules explained in this presentation WILL save you mips and money.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

To index or not to index

To explain the explain and it's access paths

Predicate solving when and how

Suboptimal coding and their improvements

Other easy to use CPU saving techniques



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.