Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Using Index-Organized Table (IOT)
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
"Kenneth Koenraadt" <jks34_at_mobilixnet.dk> wrote in message
news: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 Wed Feb 28 2001 - 19:17:47 CST