Oracle Water mark

What is water mark apporach in SQL?

Questions by jagadeesh9   answers by jagadeesh9

Showing Answers 1 - 3 of 3 Answers

godsrikanth

  • Dec 3rd, 2009
 

A High Water Mark is when a database (or database table) has reached its maximum capacity, for example, the EMPLOYEE table including current and past employees, could have 1000 rows. That would be its high water mark. If you laid off 500 employees, the high water mark remains.  TO reset the high water mark, you will have to drop and re-create the table and re-import the data.


Thanks
Neo

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions