Re: Index Size

From: Jens Schauder <jens.schauder_at_opal-edv.com>
Date: Fri, 29 Oct 1999 02:39:10 -0700
Message-ID: <38196B3E.23B3D132@opal-edv.com>

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!!!!!
Received on Fri Oct 29 1999 - 04:39:10 CDT