---

Updating records in a file

---

• Updating fixed length records
  • Trivial:

    In place update (Because the size does not change. The new value will fit)

  ---

  ---

  ---

  ---

• Updating variable length records
  • Handle an update as:

    Delete the record Insert the updated record

    Comment:

    This may result in a forwarding reference (index) to the newly inserted record if the inserted record is stored in an overflow block !!! Graphically:

    ---

  • Note:

    We will never create a tombstone record in an update operation !!!