Data Management

Design of Indexing

Date Added: May 2010
Format: PDF

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.