Row ID Stability

The row ID of rows in an RLV-enabled table may change.

In TLV tables which reside completely on the IQ main store, when a row is inserted, its row ID is stable for the lifespan of that row. Once the row is deleted, the row ID is available to be assigned to a newly inserted row.

In RLV-enabled tables, an inserted row is assigned a temporary RLV row ID.

The temporary row ID assigned to a row in the RLV store is guaranteed to be stable only for the duration of each transaction to which it is visible. Its row ID becomes permanent only after the row has been both committed and merged into the IQ main store