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

dan2098_at_aol.com (Dan2098) writes:

>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.

              delete
>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

A select count(*) on the table after the deletion takes a long time because Oracle makes at tablescan until the highwatermark.

Kind ragards
Hans Jokumsen

--

 Hans J. Jokumsen  
 Denmark