Re: DB2 HADB

From: Mark A <nobody_at_nowhere.com>
Date: Fri, 25 Nov 2005 16:18:13 -0700
Message-ID: <joqdnRywB_UtBhrenZ2dnUVZ_sudnZ2d@comcast.com>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1132959947.306333_at_yasure...
> Wrong again! Thanks for the encore.
> --
> Daniel A. Morgan

Maybe you can explain why IOT's are not often used in Oracle, while table clustering is quite common for DB2 tables (at least for knowledgeable DB2 DBA's).

I will give you a hint: IOT's have much higher overhead than table clustering in DB2, however, if a table is clustered in DB2 one must reorg the table to reestablish the freespace for new inserts (except for read only tables).

Reorgs are not performed very often in Oracle, as noted by Noons (except perhaps if a large percentage of rows have been deleted). Received on Fri Nov 25 2005 - 17:18:13 CST