Hi Arthur,
High water mark is reset or set when you perform DDL statements only and
even if you delete all the records from the database still HWM will be
pointing to the end of the block where data was previously stored and it is
better to use truncate table command which resets the HWM for performance
considerations.
Thanks,
Murali Chintaman
amerar_at_theocc.com wrote in message <782hph$bb7$1_at_nnrp1.dejanews.com>...
>
>
>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
Received on Tue Jan 19 1999 - 22:07:25 CST
