Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What are the advantages of an IOT?
"Harry Wild" <h.wild_at_elegene.de> wrote in message news:<9lau4a$4k9$1_at_wsc10.lrz-muenchen.de>...
> Hi!
>
> Can someone tell me the advantages of an index-organized table over the
> standard one?
> Is it faster? I have a table with some 100.000 records (small ones), some
> 10.000 new entries per week, and once inserted records don't change. Is it
> better to make an IOT of this table?
>
> Thanks,
> Harry Wild
>
> BTW, I'm using Oracle 8.1.7
Harry:
An IOT is where all the data of the table is stored right in the Index segment, along with the indexed values. So, obviously, less IO will typically be required to retrieve the data once the index entry is found.
Tom Best Received on Tue Aug 14 2001 - 10:09:39 CDT