Interested to Buy Any Domain ? << Click Here >> for more details...
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.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
how to decrement dates by 1 in mysql? : Sql dba
How do I make my sql query run faster?
What is composite data type in pl sql?
What is rowtype?
What is on delete set null?
What is primary key sql?
which operator is used in query for pattern matching? : Sql dba
what is index? : Sql dba
Why do we use joins in sql?
what is a trigger? : Sql dba
How can we debug in PL/SQL?
Enlist the characteristics of pl/sql?
How does a self join work?
Which query operators in sql is used for pattern matching?
How to rename a table?
