Re: ASSM vs. non-ASSM

From: mhoys <matthias.hoys_at_gmail.com>
Date: Thu, 26 Jan 2012 01:01:18 -0800 (PST)
Message-ID: <744fd133-7cee-4505-bbd0-96ed583c8f1c_at_k28g2000yqc.googlegroups.com>



On Jan 25, 9:21 pm, "Gerard H. Pille" <g..._at_skynet.be> 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