Articles & Content

Archives

Proactive Index Design using QUBE (F04)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2010



DATE: 2010-11-9 (08:30 - 09:30)
SPEAKERS: Lauri Pietarinen (Relational Consulting)

Surprisingly, after years of using database technology, indexing is at many sites a dark area and one often finds databases with loads of one-column indexes. But what is a good index and how do we estimate it's effectiveness before the fact? One solution is to use QUBE, the Quick Upper Bound Estimate, a simple method developed by Tapio Lahdenmäki. In this presentation we also talk about the benefits and trade offs of fat (covering) and semi fat indexes and what makes an index (or a set of indexes) "perfect" for a given SQL-query.

EXP. LEVEL: Intermediate

OBJECTIVES:

Learn about outdated indexing myths and misconceptions

Learn how to evaluate query and index performace proactively (on paper)

Understant benefits and tradeoffs of "fat" and "semifat" indexes

Understand how optimal indexing strategies have changed with modern hardware

Discuss roles and responsabilities of index design between designers, developers and DBAs



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.