Performance Tuning And Optimization Of DB2 Database Index

Database optimization involves a number of aspects and is a complex work. From the bottom hardware to the operating system, database management systems, middleware and then to the upper application, each of which affect the performance of the database. To get good performance for the database, we should do overall cosideration to these factors and remove bottlenecks. In order to implement this, we need to establish a methodology and process of tunning performance. We can make our optimization strategy complete based on the methodology and process.This article raise a set of methods and processes for database performance tuning and optimization, including setup performance indicators, performance objectives, performance tuning steps and processes of optimization. According to these we can systematically optimize the database performance.Index is an everlasting important topic for the database performance. This article first detailedly analysis the DB2 index structure, access mechanisms, and then combined with the samples and characteristic of DB2 database, We make a detailed analysis of the concept of index design and propose some principles of index performance optimization. It has good theoretical and practical value for improving performance of database.