Re: Can anyone explain exactly what is meant by high water mark?

If you have a table with 500,000 rows, the high water mark is at the last row inserted. If you rows from the table, the high water mark is not moved. Truncating the table resets the high water mark back to the beginning of the table, and I believe that this is the only way to move the high water mark.

Hope this helps.

dan2098_at_aol.com Received on Fri Feb 20 1998 - 00:00:00 CST