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

In article <KO6y4.496$a24.3549288_at_nnrp3.proxad.net>, "Eric DUCHET" <eric.duchet_at_free.fr> wrote:
>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
>
>

I read the rest of the thread, and didn't see anyone ask if they were bitmap indexes. Unless I am mistaken Oracle has a problem/feature with updates/inserts into bitmapped indexes that make them grow extremely large, extremely quickly.

Scott Gamble

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!