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 assignment operator in pl sql?
What is the meaning of disabling a trigger?
What is the difference between execution of triggers and stored procedures?
What is a table partition?
How many joins can you have in sql?
Give the order of sql select?
Can we join more than 2 tables in sql?
What is trigger and how to use it in sql?
what is the difference between where clause and having clause? : Sql dba
Which is better varchar or nvarchar?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
what are null values? : Sql dba
How do we accept inputs from user during runtime?
What are conditional predicates?
Can function return multiple values in sql?
