HOT Update

Heap-Only Tuple update — an optimization where an updated row can be stored on the same heap page as the original, avoiding index updates. Requires that no indexed columns changed and the page has free space.