First page Back Continue Last page Graphics

Resetting HWM

DELETE does not reset the high water mark
Alternatives
- ALTER TABLE t MOVE;
- Partitioning
  - TRUNCATE or DROP partition
- CREATE TABLE AS SELECT
  - Copy desired rows to new table
  - Drop old
  - Rename new
- If all rows to be deleted, consider TRUNCATE

Notes:

If you regularly purge large amounts of data, consider these alternatives to the DELETE statement.