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
What is java sql driver?
How do you copy a table in sql?
What does pl sql developer do?
how to dump a table to a file with 'mysqldump'? : Sql dba
Does sql full backup truncate logs?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What is form and report?
What is pl sql and why it is used for?
What is execution plan in sql?
What are the different types of functions in sql?
What does subquery mean in sql?
how can we know the count/number of elements of an array? : Sql dba
What is an example of translating a date into julian format?
Which is faster view or stored procedure?
What are the different dml commands in sql?
