A Simple Approach to DB2 Index Redesign

By: Michael Findling

Abstract: This presentation reviews index structure and discusses a number of ways to redesign indexes without affecting application integrity.

This presentation reviews index structure and discusses a number of ways to redesign indexes without affecting application integrity. This presentation applies to all DB2 platforms and examples come from the presenter’s experience. The use of IBM’s Explain is also shown.

  With Martin Hubel of Martin Hubel Consulting Inc.

DBArtisan is the leading cross-platform database administration tool that helps DBAs maximize the availability, performance, and security of their databases. Download a free 14-day trial at our download center today!

Server Response from: ETNASC01