Re: Using Index-Organized Table (IOT)

The major drawback is the administrative overhead connected with IOT.

Besides, the new and improved tuning techniques make IOT's obsolete in nearly all (non-extreme) cases.

The reason why developers rarely use IOT's ? Well, my guesses :

1. Unawareness of their existence and proper use.
2. Awareness of the fact that use of IOT is rarely justified.
   • Kenneth Koenraadt plovmand_at_hotmail.com

Putrasto skrev i meddelelsen ...
>Dear all,
>I am new in Oracle, after reading the manual
>i found that IOT table is good for my project because it's fast.
>and i want to use it in transaction table as well.
>my question is is there any drawbacks (beside in documentation)
>for using this table type?
>and why developer very rare in using this table ?
>Any comments , experience , will be appreaciated.
>
>Regards,
>Putrasto
>
>
>
>
Received on Wed Feb 28 2001 - 12:10:05 CST