Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DB2 HADB
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