Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Index-organized tables
Hi,
You can modify IOT table and coulmns to it. IOT table is basically stored in index segment not in table segment and is very useful for query which access data using primay keys(e.g. lookup
table as you mentioned). Data access from IOT table is very fast because oracle does not have to do two I/Os(One for index and other for table) to get the data.
Thanks
Pavel Vetesnik wrote:
> Hello,
>
> is it possible to modify (alter) index-organized table?
> In documentation I read, that "you cannot ADD columns to an index-organized
> table, but you can alter the definition of an index-organized table.". But
> it seems I can do it.
>
> To following code surprisingly works for me:
> ======================================================
> CREATE TABLE source_type
> (short_name CHARACTER(3) PRIMARY KEY,
> name VARCHAR2(25) UNIQUE)
> ORGANIZATION INDEX
> STORAGE (INITIAL 20k NEXT 10k PCTINCREASE 0);
>
> ALTER TABLE source_type ADD (some_column VARCHAR2(500))
> ======================================================
>
> So how it is? Can IOT table be modified or not (or sometimes not).
>
> Do you think it is good idea to use IOTs for small lookup tables, that are
> updated very seldom?
>
> Thank you in advance,
> Pavel
>
>
Received on Fri Aug 29 2003 - 04:57:50 CDT