db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

A HOT update

If no indexed column changes and the page has room, the new version stays on the page and no index entry is added. Flags in t_infomask2 mark it.

task

Update n of id 1, then return lp, hot_updated (t_infomask2 & 16384 <> 0) and heap_only (t_infomask2 & 32768 <> 0) for line pointers 1 and 101, ordered by lp.

hints