DPsireesha

 Profile Answers by DPsireesha Questions by DPsireesha

• Feb 24th, 2009

 

The High Watermark is the maximum fill-grade a table has ever reached. The
blocks above high water mark are empty blocks.

Initially when you create a table the high water mark is the first block. When
you insert rows on the table the high water mark increases step by step.

The high water mark will not be changed when you delete the rows.

For example If you insert 1000 rows in a table and deletes 500 rows then the
High water mark will stay at the level of 1000 rows.