Hi,

In DB2 vesion 8.1 exist multi-dimensional clustering (index type)

Multi-Dimensional Clustering - Benefits:
- Faster Query speed
- Access only the data pages necessary - no searching
- Get all the data in a few accesses versus 100s of page reads
- Reduces CPU & disk I/O use for other users to leverage
- Simple & Intuitive --Multidimensional keys and Star Schema friendly
- Perfect for OLAP style hierarchical analysis
- Executive reports, Summaries, etc.
- Reduces index size --Saves disk, faster queries
- One index entry covers entire data page, not one per row
- Reduces DBA reorg's --row clustering managed by DB2
- FASTER DELETES --JUST DROP A FEW DATA PAGES
- Faster Inserts --store the record, but rarely insert an index entry

Grofaty