What is High Water Mark(HVM) in oracle and how it effects the performance of queries?

Опубликовано: 15 Сентябрь 2024
на канале: Kishan Mashru
11k
156

This video tutorial is to understand the concept of a High Water Mark or HVM of a oracle table, also it states the various changes in the HVM when we perform a insert, delete and Truncate operation on the table, and the video also informs why is the truncate operation more advisable and optimized then the delete operation.