View Printable Version

Improving Query performance in DB2 LUW Warehouses

Session Number: 371
Track: Educational Seminars
Session Type: Podium Presentation
Primary Presenter: Calisto Zuzarte [Manager, DB2 Query Compiler CE, STSM - IBM]
Room(s)/
Time(s):

Bonaire 7&8 => Mon, Apr 29, 2013 (08:30 AM - 05:00 PM)

Speaker Bio: Calisto Zuzarte holds the following position :
Manager, DB2 Query Compiler CE, STSM,
Centre For Advanced Studies (CAS) Research Staff Member

Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Managing Performance
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Data Architects, Database Administrators
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), New Release (DB2 for LUW)
Objective 1: Discuss The DB2 optimizer (Query Rewrite and plan optimizer)
Objective 2: New features in DB2 10 ( zzjoin, hsjn, complex queries, compression etc)
Objective 3: - Physical Design (focus on partitioning)
Objective 4: - Performance Problem Determination (steps that I take to look for problems)
Objective 5: - Optimal Indexing (tuning using indexes)

Abstract:  - The DB2 optimizer (Query Rewrite and plan optimizer)
- New features in DB2 10 ( zzjoin, hsjn, complex queries, compression etc)
- Physical Design (focus on partitioning)
- Performance Problem Determination (steps that I take to look for problems)
- Optimal Indexing (tuning using indexes)
- Getting Cardinality estimation right (tuning with better statistics)
- Configuration that affects plans (tuning configuration)
- Constraints (tuning using constraints)
- Result caching (tuning using MQTs)
- Organizing data (tuning data layout)
- Application query design (tuning by manually writing queries)
- Workload performance (tuning using WLM)

For questions or concerns about your event registration, please contact support@idug.org