Re: index-organized tables

blair_at_pjm.com wrote:

> We have a class of data which is very-high-volume insert, never update. We are
> investigating migrating those tables from regular tables to Index-organized
> tables.
>
> But in IOT it seems to me that since the table is organized like an index, there
> might be additional load required for insert since rows must be located into the
> b-tree index structure instead of just appended to the end.
>
> Anyone have any experience with IOT that they could share? Any comments on my
> presumption?
>
> thanks,
>
> .tom
>

Tom,

   I cannot comment about the actual delta between IOT and heap tables as far as pure inserts are involved. Don't forget though that since the tables are organised as indexes, you can spare at least one index (PK) which would normally have to be inserted, so the difference is not exactly what it looks like - unless you insert into an index-less table ?
I have a hands-on experience of intensive inserts (target is 2,000,000 rows per minutes) into partitioned IOTs, and it seems to bear the load.

Regards,

Stephane Faroult Received on Tue Jan 16 2001 - 13:29:37 CST