DB2 Performance Summary Part 1

Over the last four months, we have examined in-depth the DB2 performance problems that might be found in a typical DB2 installation. My purpose in doing this was to show you how a DB2 performance analysis and methodical review can help you discover ways to reduce system costs. Good application review and positive changes can . . . → Read More: DB2 Performance Summary Part 1

The Effect of Indexes on DB2 Performance

The trail for the hunter of performance problems leads from the DB2 table to its indexes. As I went deeper into this DB2 performance jungle, I discovered more interesting artifacts.

DB2 Index

Since the table I talked about in the last post was typical of other tables in other applications in the company, it made . . . → Read More: The Effect of Indexes on DB2 Performance