Business Intelligence

Summary

As with all databases, indexes and statistics play an important role in improving query performance on an iSeries server. In addition to assisting in data retrieval, DB2 UDB for iSeries indexes also provide valuable information to the cost-based optimization of query requests. This ability to provide the optimizer with information about data skew and column cardinality becomes critically important as databases scale into the hundreds of gigabytes and eventually terabytes of data. The Statistics Manager within DB2 UDB for iSeries greatly enhances productivity and allows the SQE optimizer to learn about and react to changes autonomously. This is very important in an "on demand" environment.

[Back | Next]