A standard stream tracks table changes. An analyst SELECTs from it without a consuming DML transaction. What normally happens to its offset?

Published
  1. The source table is truncated
  2. The SELECT alone does not consume the stream offset
  3. Every SELECT permanently advances the offset
  4. The stream becomes an immutable full backup

Comments — 0