Now if we insert some data into the table segment, the HWM moves and it will be at position up to which the data is in the segment
If insert more data in the table segment, HWM moves further to point the position up to which the data is in the segment
As we can see above on deleting the data, HWM does not move. The drawback of this is that oracle always read the blocks up to high water mark in case of full table scan. You must have noticed that doing a count (*) on empty table, takes time to show you no rows. The reason for taking so much time is setting of HWM at higher position.
Now you must be thinking , how to set the high-water mark at lower position ?
The only method to set the HWM is to truncate a table.
Let us see how truncate set the HWM.
Now you must be thinking , how to set the high-water mark at lower position ?
The only method to set the HWM is to truncate a table.
Let us see how truncate set the HWM.
No comments:
Post a Comment