Anchorage API reference
    Preparing search index...

    Variable START_IDEMPOTENCY_RUN_INDEX_DDLConst

    START_IDEMPOTENCY_RUN_INDEX_DDL: "CREATE INDEX IF NOT EXISTS flowsafe_start_idempotency_run\n ON flowsafe_start_idempotency (run_id)" = ...

    run_id is how the RUNTIME finds a reservation (terminal reconcile knows the run, never the key) and how the purge pairs a reservation with the snapshot it outlived. Without the index both degrade to a table scan on every terminal run.