Re: Using Index-Organized Table (IOT)

The administrative overhead with IOT's occurs in connection with the creation parameters pcttreshold and overflow (see Oracle documentation). In many cases, that may
not be a problem.

What may be worse is the fact that IOT's cannot be partitioned or replicated (see Oracle documentation).

With these potential problems in mind, only use IOT's when you have a good reason.

If it can help make your application faster by saving a sort, that may be a good reason. It's a case-specific trade-off. Just remember that applications change but tables remain ( mostly ;-) )

• Kenneth Koenraadt plovmand_at_hotmail.com

Putrasto skrev i meddelelsen ...
>Dear Kenneth,
>Could you be more detail/specific about administrative overhead connected
 to
>IOT?
>if we compared with non IOT table (but already indexed).
>For your information i found that if i use IOT
>i don't have extra overhead for sorting because table already been sorted.
>OK that was another subject. But this feature is realy interesting for me.
>
>Regards,
>Putrasto
>
Received on Thu Mar 01 2001 - 08:52:22 CST