Re: Using Index-Organized Table (IOT)

have you noticed that IOT table automatically sorted when you insert or delete rows?
So i think it will be best for 'paging', because i don't need to sort the table for move next page or previous page. Even the documentation tells not to depend on this automatic sorting still SQL with 'sort by' has very little overhead on IOT table. Thank for your suggestion with implementation on reference table I absolutely agree with that.

"The Saint Nimnul !" <stnimnul_at_mail.ru> wrote in message news:97kras$109m$1_at_oak.rt.ru...
> 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 - 23:29:29 CST