Data Management

Design of Indexing

Download Now Free registration required

Executive Summary

One of the major aspects of performance enhancement in DB2 is an Index. Changes to the indexes of the DB2 tables used in the SQL query processing of a batch application would have a direct impact on the performance of the query and hence so to the Batch cycle time. So it becomes mandatory to include Indexing and clustering of indexes as a vital metric for a performance tuning exercise.

  • Format: PDF
  • Size: 329.7 KB