Re: DB2 HADB

From: Mark A <nobody_at_nowhere.com>
Date: Fri, 25 Nov 2005 16:12:49 -0700
Message-ID: <P7KdnT3HWJvxBxrenZ2dnUVZ_sCdnZ2d@comcast.com>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1132959905.790321_at_yasure...
>
> You respond to one question (thread 'Commit after transaction compelte')
> by answering a question while acknowledging the OP was unclear. Now you
> make a statement (this thread) out of similar ignorance:
>
> -- watch for wrapping of long URL
> http://www.oracle.com/pls/db102/search?remark=quick_search&word=Create+Cluster&tab_id=&format=drilldown
>
> What do you plan for an encore?
> --
> Daniel A. Morgan

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.

The references to clustering you posted have a different meaning than table clustering in DB2. I was not attempting to make a comparison of Oracle vs. DB2 in terms of which is best or which has the most features. I was answering the question as to why DB2 DBA's are more interested in reorging tables than Oracle DBA's. Received on Fri Nov 25 2005 - 17:12:49 CST