Re: ASSM vs. non-ASSM

From: mhoys <>
Date: Thu, 26 Jan 2012 01:01:18 -0800 (PST)
Message-ID: <>

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 Received on Thu Jan 26 2012 - 03:01:18 CST

Original text of this message