Re: High Water Mark

From: <rspeaker_at_my-dejanews.com>
Date: Tue, 19 Jan 1999 20:59:56 GMT
Message-ID: <782ro4$klg$1@nnrp1.dejanews.com>

the HWM is the maximum amount of data that has been stored in the given object (table, index, etc), just like the high water mark on a river pole is the highest point the river has ever reached. The only way the HWM can be reset on tables is by truncating the table...deleting records does NOT reset the HWM.

HTH,
Roy

In article <782hph$bb7$1_at_nnrp1.dejanews.com>, amerar_at_theocc.com wrote:
>
>
> Hello,
>
> I am a bit confused about what the high water mark is and what its effects
> are. I'm confused about what happens to the HWM when you delete records from
> a table and also when a table grows.
>
> Any help is appreciated.
>
> Please send comments to my e-mail.
>
> Thank you,
>
> Arthur
> amerar_at_theocc.com
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Jan 19 1999 - 14:59:56 CST