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
What is the most common sql injection tool?
What is sp_helptext?
How much does a sql dba make? : SQL DBA
What is the basic form of sql query?
Differentiate between syntax and runtime errors.
Is postgresql a server?
What is form and report?
Explain character-manipulation functions?
What is a table in a database?
What are hotfixes and patches?
Can you join a table to itself?
How many columns should be in an index?
What is cartesian join in sql?
What is rowtype?
What language is oracle sql developer?
