Glossary

Why this pattern works at scale:

The cursor uses `WITH HOLD`, so it survives the COMMIT without requiring repositioning. - The restart key is always the natural ordering key of the cursor, so restart is a simple WHERE clause modification. - The MERGE into the restart table is atomic with the data changes — both are in the same comm

Learn More

Related Terms