Re: delete high water mark question

From: james f. koopmann <jkoopmann_at_servman.com>
Date: Fri, 24 Sep 1999 07:00:09 -0600
Message-ID: <rumtk4oalg77@corp.supernews.com>

anurag,
if the length of the rows you are inserting are relatively the same for this data then the high water mark will stabilize at some level. you will have to watch the indexes associated with this table especially if you have an increasing key. indexes tend not to reuse space very well under certain circumstances.

james koopmann
jkoopmann_at_servman.com
www.servman.com

Anurag Minocha <anurag_at_synergy-infotech.com> wrote in message news:37EB59F2.371F14FD_at_synergy-infotech.com...
> Hi ,
> I have a question that suppose we have 1 lac rows in a table , the HWM
> is set to a particular value. Now i delete 75000 of the rows the HWM
> still remains the same.Again if i insert some 70,000 rows will the HWM
> increase or will it remain the same.
>
> I have to follow this procedure everyday in our database and am worried
> whether performance will go down or not.
>
> reply at
> anurag_minocha_at_hotmail.com
>
Received on Fri Sep 24 1999 - 08:00:09 CDT