Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can I store data in the indexes and not the tables ?
In Oracle 8 you can have an IOT (Index Organized Table) which is what you
are probably looking for.
Jim
Stephen Vear wrote in message <7cqkka$5io_at_romeo.logica.co.uk>...
>I have an index onto a table where the index consists of almost all of the
>attributes of the table. The size of the index is actually bigger than the
>table. It is therefore duplication to also store these values in the
table.
>Is there a way to tell Oracle that some of the attributes should only be
>stored in the index ?
>
>And if so, then what if one of these attributes is a foreign key to another
>table.
>
>TIA
>
>Stephen Vear
>vears_at_logica.com
>
>
>
Received on Thu Mar 18 1999 - 07:19:42 CST