View Single Post
  #12 (permalink)  
Old 02-12-03, 08:43
grofaty grofaty is offline
Registered User
 
Join Date: Jan 2003
Posts: 1,563
Re: Question about Delete some rows from large table

Hi,

Yes you are probably right. MDC indexing is not sutible for OLTP systems. But it can be useful in warehouse environments.

I haven't tested it yet, but it seem to be very promising...

Grofaty

Quote:
Originally posted by eherber
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
***********************************************
Reply With Quote