Articles & Content

Archives

Improve Performance by Analyzing DB2 LUW Access Strategies (C10)

Topic: DB2 for LUW

Subtopic: 2011



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

OBJECTIVES:

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.