db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

Boss: ten updates, ten HOT records

An UPDATE that changes no indexed column and fits on the same page is HOT. WAL logs it as Heap HOT_UPDATE, not UPDATE. lab.mark.l1 is the LSN taken before your work.

task

Update n for ids 1 to 10 of lab.t, then return the number of Heap HOT_UPDATE records since lab.mark.l1.

hints