Answer / gourvendra singh

Highwatermark means the largest amount of data that was
placed in the table. for ex you are having a table which is
having 100 records, now ur highwatermark is 100, now you
add 10000 record more in the table ur highwatermark will
raise to 10000, nd if you delete all the records ur
highwatermark will remain on 10000, thats why in these case
query takes some times as it scan upto 10000. that why we
should use truncate in case of deleting all the records. as
the truncate cammand will remove the highwatermark and ur
processing will be faster.

for any query pls contact:
Gourvendra Singh
9873367485.

Answer / suresh kumar somayajula

High Watermark : It's an indicator or Porinter upto which
a Table or Index has ever contained
data .

Answer / 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.
------- DATA-----------------
Un-Used Blocks





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

DATA
------- 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.

When sql appeared?

0 Answers  

---

Why do we need cursor in pl sql?

0 Answers  

---

What is pseudo column ?

6 Answers   ABB,

---

What is NOCOPY?

6 Answers   DELL,

---

Can a view be mutating? If yes, then how?

0 Answers  

---

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers  

---

What are views in sql?

0 Answers  

---

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

4 Answers  

---

What is sql and its types?

0 Answers  

---

write a query that returns first characters of each word in Oracel/Sql pl sql

5 Answers  

---

How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

---

Does truncate release storage space?

0 Answers  

---