Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DB2 HADB

Re: DB2 HADB

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Fri, 25 Nov 2005 16:01:47 -0800
Message-ID: <4387A5EB.3090804@comcast.net>


Mark A wrote:

>
> The ignorance is yours. Oracle does not have table clustering in the same
> manner as DB2 unless you create an index ordered table, which has much
> higher overhead to maintain the exact order. IOT's are not used very often
> Oracle (because of the high insert overhead), while table clustering is
> common (but not universal) in DB2.
>

You are talking about a clustering index in DB2 parlance, correct ? Why do you think that Oracle's table clustering (supporting both single and multiple tables, as well as hash clustering) is not similar (and indeed, possibly a superset) to what IBM provides ? Received on Fri Nov 25 2005 - 18:01:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US