Index size growing abnormally .....Oracle bug ?

From: Eric DUCHET <eric.duchet_at_free.fr>
Date: 2000/03/10
Message-ID: <KO6y4.496$a24.3549288@nnrp3.proxad.net>#1/1

Hi,

I have a database with lots of inserts and a lot of index. I have at the start 1 million rows on a table, and indexes on that table. The ratio total rows size/total index size is nearly 1.

I insert a lot of rows in my table (about 1 million). When i recompute the ratio row size/index size is about 3. I rebuild my index and the ratio has been decreased to 1. (1 Go has been freed with the reorganisation!)

My conclusion is that the index size grows abnormally. I think this is an Oracle bug.
And a reorganisation must be done when the ratio data/index is growing to resolve this bug.

Is there anonybody have this problem ?
Is there any solution to resolve that ?

Thanx Received on Fri Mar 10 2000 - 00:00:00 CST