Articles & Content
Topic: 2010 EMEA
Subtopic: Cross Platform DB2 for z/OS & LUW
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
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
This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.