Articles & Content


Improve Performance by Analyzing DB2 LUW Access Strategies (C10)

Topic: 2011 NA

Subtopic: DB2 for LUW

DATE: 2011-5-5 (09:45 AM - 10:45 AM)
SPEAKERS: Melanie Stopfer (IBM )

Do you want to better understand and tune your DB2 LUW database? Are you looking for tips to make your life easier? By analyzing EXPLAIN output, Melanie will present analogies and insider advice to help you improve performance and availability. Come learn new DB2 LUW ideas, tips and enhancements that you need to know.

EXP. LEVEL: Intermediate,Advanced


Gain knowledge on index utilization and improving access

Analyze the details of predicate processing and the value of column correlations

Improve query performance

Learn how the optimizer calculates filter factors

Improve sort performance

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.