Beside repeating the IBM marketing messages,
did you ever verify this ?
I doubt that MDC indexing is that useful in OLTP
environments. Also I doubt that a EEE or in
V8.1 a ESE with multiple partitions is really
useful in HighEnd OLTP environments.
Informix might be (at least today) the better choice.
Best regards
Eric
--
IT-Consulting Herber
WWW:
http://www.herber-consulting.de
Email:
eric@herber-consulting.de
***********************************************
Download the IFMX Database-Monitor for free at:
http://www.herber-consulting.de/BusyBee
***********************************************
Quote:
Originally posted by grofaty
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
|