Re: Index Size

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sun, 31 Oct 1999 19:36:01 +0800
Message-ID: <381C29A1.4D29@yahoo.com>

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!!!!!
Check the analyze command to see how to really get a good look at how the space is being used on the index....However, it is not unusual to have indexes using more space than the table itself.

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sun Oct 31 1999 - 05:36:01 CST