Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is Highwatermark?

Answer Posted / p.rajasekar

High-water mark is an indicator or pointer up to which
table or index has ever contain data. Let us illustrate
this statement as Suppose we create an empty table , the
high-water mark would be at the beginning of the table
segment.
After inserting data in the table segment , the HWM moves
and point the position up to which the data is in the
segment.By inserting more data in the table segment, HWM
moves further to point the position up to which the data
is in the segment.
&#61663;------- DATA-----------------&#61664;
Un-Used Blocks





Now let us delete the data and see the pointer of HWM

DATA
&#61663;-------&#61664; Empty Blocks Un-Used Blocks



Full Table
Scan

As you seen above by deleting the data , HWM does
not move. The main disadvantage of this is that oracle
always read the blocks up to high water mark in case of
full table scan . You may have ever notice that doing a
count(*) on empty table , takes time to show you 0 rows.
The reason for delay is setting of HWM at higher position.

Now the question arises in front of us , how we set the
high-water mark at lower position ?
The only way to set the HWM is to truncate a table.

Let us see how truncate set the HWM.

No data in the segment



HWM is reset now , after truncating data.

Table where lots of deletion or insertion takes place ,
probably has High HWM. If the HWM is high , it is better
to rebuild table segment for performance sake.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between function and procedure in pl/sql?

1081


What does partition by mean in sql?

960


Is sql open source?

970


how can we submit a form without a submit button? : Sql dba

985


What is java sql connection?

1054


What is trigger in sql and its types?

1055


What is orm in sql?

1046


Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1074


how can you create an empty table from an existing table? : Sql dba

1153


Does truncate require commit?

971


What is asqueryable?

967


what is the functionality of the function htmlentities? : Sql dba

953


What is sql dialect?

1114


What is sp_helptext?

1064


how to convert numeric values to character strings? : Sql dba

1105