Materialized query tables have been available on DB2 on platforms other than the iSeries for some time. Is this feature planned to be included in a future release of OS/400? If so, when? Until then, are there any alternatives currently available for the iSeries?
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
Dig Deeper on iSeries CL programming
Related Q&A from Kent Milligan
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ... Continue Reading
When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC ... Continue Reading
When developing tables in a parent-child relationship, use a primary key and a foreign key along with a unique ID to make your database easier to ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.