Re: Indexes question

I think it's a normal situation, because if your original table has only one field, URL, it will use only
the space of that field, and the index table will have the complete field indexded, and another field to
locate the row in the original table.
I think that in Oracle 8 you can have for this situation an index over a virtual table. Oracle tells you that
you have a table with its index , but it only stores the index.

HTH
Luis Temes

Andrey Bronfin wrote:

> Dear DBAs !I'm having a very strange situation here , so i just must
> have your help . There is a table URLS , which has a column URL of
> type varchar2(740) .I have a single-column index URL_IX defined on
> that column .Now , by querying the DBA_EXTENTs , i see that the index
> URL_IX occupies more space ( bytes , blocks , extents ) than the table
> itself .Is it a normal situation ?Is it effective to define such an
> index on a varchar2 (740) column and search it ?Is there a more
> effective way to index such a column and to optimize the access to it
> ? Thanks a lot in advance !
> Andrey Bronfin
> VisualTop.com
Received on Mon Jul 03 2000 - 04:40:34 CDT