Xref: alice comp.databases.oracle.misc:45679
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!feed1.news.rcn.net!rcn!newsfeed1.earthlink.net!nntp.earthlink.net!posted-from-earthlink!not-for-mail
From: Jens Schauder <jens.schauder@opal-edv.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Index Size
Date: Fri, 29 Oct 1999 02:39:10 -0700
Content-Transfer-Encoding: 7bit
References: <3818DF47.4B1097AA@earthlink.net>
X-Posted-Path-Was: not-for-mail
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-ELN-Date: 29 Oct 1999 00:47:55 GMT
X-ELN-Insert-Date: Thu Oct 28 17:55:17 1999
Organization: EarthLink Network, Inc.
Lines: 24
Mime-Version: 1.0
Message-ID: <38196B3E.23B3D132@opal-edv.com>
X-Mailer: Mozilla 4.7 [en] (WinNT; I)

Hi my Name

Things like this might happen if your tables don't have much
data in it except in the columns indexed.
If you have multiple indexes the added size might even exceed
the table size and these tables are still helpfull.

anyway you might check amount of free space inside the idices
and tables, it might be sensible to recreate them

Jens

My Name wrote:
> 
> Hello,
> 
> I have a database with total table size of approx. 60MB, then I found
> out that my index size associated to all those tables are also 60MB.  I
> do have one particularly large table and it does have 4 columns
> indexed.  But still, it seem kind big.  I didn't created the database.
> so, I want to know if this is possible and with indexes as big as
> tables, does actually help??
> 
> THANK YOU!!!!!