Answer Posted / 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.

What is rename command in sql?

1093

---

What is the use of partition by in sql?

1045

---

How to set up sql*plus output format in oracle?

1082

---

What trigger means?

1036

---

What are analytic functions in sql?

1074

---

What are different types of tables in sql?

1051

---

how are mysql timestamps seen to a user? : Sql dba

1195

---

What is data type in database?

1042

---

What are % type and % rowtype?

1081

---

What is the starting oracle error number? What is meant by forward declaration in functions?

1042

---

What is a primary key example?

1002

---

Does a user_objects view have an entry for a trigger?

1050

---

what is the difference between group by and order by in sql? : Sql dba

1188

---

what are the advantages a stored procedure? : Sql dba

1019

---

what is union? : Sql dba

1082

---