Re: ASSM vs. non-ASSM

From: mhoys <>
Date: Fri, 27 Jan 2012 01:09:33 -0800 (PST)
Message-ID: <>

On Jan 27, 9:29 am, "Gerard H. Pille" <> wrote:
> onedbguru wrote:
> > Yes, but the next time you need "more space" for that index it is
> > already allocated and will be used.
> This is false.  The indexes keep growing for the same amount of data and queries using these
> indexes become too slow.

I would like to answer with "it depends" :-) Btw, I tried to develop a test case to show the performance difference between "normal" and "soufflé" B-tree indices, but I haven't been successful so far. This is on, ASSM tablespace with automatic extent allocation... What are the properties of your system, Gerard?

Matthias Hoys Received on Fri Jan 27 2012 - 03:09:33 CST

Original text of this message