Re: Using Index-Organized Table (IOT)

In oracle's documentation said clearly that IOT is the best choice for reference tables. I think as well. And i use IOT for this purposes, particularly for BIG historical non-updateble tables (in this case i save plenty of disk space:-)).

Kenneth Koenraadt <jks34_at_mobilixnet.dk> ÐÉÛÅÔ × ÓÏÏÂÝÅÎÉÉ:O0bn6.10$D_.3275861_at_news.mobilixnet.dk...
> 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 Thu Mar 01 2001 - 00:51:57 CST