Another performance booster is multi dimensional clustering, which is something new even on other platforms. But given the architecture of the iSeries, are features such as these possible/necessary on the iSeries?
Materialized query tables is a feature that IBM is working on for a future release. There are no easy alternatives.
Mutli dimensional clustering may be something considered for a future release, but we'll also probably look at leveraging encoded vector indexes more. The base that the V5R2 SQL Query Engine provides will make it enhance DB2 UDB for iSeries engine with performance enhancements like you mentioned.
================================== MORE INFORMATION ON THIS TOPIC ==================================
Search400.com's targeted search engine: Get relevant information on DB2/400.
The Best Web Links: tips, tutorials and more.
Check out this Search400.com Featured Topic: Database issues resolved
This was first published in July 2003