DB2 for LUW

Improve Performance by Analyzing DB2 LUW Access Strategies (C10) 

May 05, 2011 03:00 PM

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

Attachment(s)
pdf file
NA11C10.pdf   346 KB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.