IDUG DB2 Tech Conference EMEA 2011
Clarion Congress Hotel, Prague, Czech Republic
14 - 18 November, 2011

View Printable Version

DB2 LUW Index Design, Best Practices, and Case Studies -Updated

Session Number: 1897
Track: DB2 for LUW Lessons Learned (D)
Session Type: Podium Presentation
Primary Presenter: Scott Hayes [President & CEO - DBI Software]
Time: Nov 16, 2011 (05:00 PM - 06:00 PM)
Room: Taurus

Speaker Bio: Scott Hayes is an IBM DB2 GOLD Consultant and IBM Information Management Champion, a frequent speaker at IDUG and regional DB2 User Group Events, is the host of The DB2Night Show‚Ñ¢ Webinar series, and author of the widely read DB2 LUW Performance Blogs. He has worked with DB2 on distributed platforms since V1 and he reads IBM documentation instead of novels for entertainment. Scott is also President & CEO of DBI, an IBM Advanced Business Partner focused on DB2 LUW and Oracle performance. Most importantly, Scott enjoys helping people.
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Managing Performance
Presentation Platform: Select a Value
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, New Users, IT Managers
Technical areas this presentation will apply to: Data Warehousing and Business Intelligence, Database Performance (DB2 for LUW), High Availability (DB2 for LUW), New Release (DB2 for LUW), User Experiences
Objective 1: How Indexes Work
Objective 2: Access Paths, Costs, and Strategies Illustrated
Objective 3: Indexes to Avoid
Objective 4: Desirable Indexes
Objective 5: Index Design Checklists for Optimum Performance

Abstract:  This technical session is all about Indexes - good indexes, bad indexes, how to create indexes, when to drop indexes, where to create indexes, index options, benefits, drawbacks, hazards, and how-to‚Äôs. With DB2 doing so much ‚Äúautomatic tuning‚Äù, physical design remains the most critical way for the DBA to directly and substantially influence performance. Case studies will demonstrate the most important index design techniques.

For questions or concerns about your event registration, please contact