Re: ASSM vs. non-ASSM

From: Gerard H. Pille <>
Date: Thu, 26 Jan 2012 20:02:19 +0100
Message-ID: <4f21a331$0$5044$>

mhoys wrote:
> On Jan 25, 9:21 pm, "Gerard H. Pille"<> wrote:
>> We have a couple of tables in which there are continuous inserts and deletes, at a dreadful
>> rate, and we have to rebuild the indexes every week, to keep size and performance in check.
>> Could not fall back to MSSM, because system is also ASSM, I seem to remember.
> "To keep size and performance in check"; I understand the size issue,
> but how do you measure the performance of your indexes before& after
> the rebuild? Do you really have significant performance improvements
> after rebuilding the indexes?
> Matthias

Yes, like 100 times faster, which I would call significant. Do you know what a "soufflé" is, and how it can fail? That's like our indexes. Received on Thu Jan 26 2012 - 13:02:19 CST

Original text of this message