Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-9582

Allow incremental snapshot using physical row identifier for connectors that support this

XMLWordPrintable

    • False
    • Hide

      None

      Show
      None
    • False

      Relates to this conversation: https://debezium.zulipchat.com/#narrow/channel/348250-community-oracle/topic/ROWID.20based.20snapshot.20for.20oracle/with/546225699

      Currently Incremental snapshots primarily make use of the primary key or alternately a surrogate-key if the table has one. It is currently not possible to pass a pseudo column like ROWID as the surrogate key due to the way that getQueryColumns works. The goal of this request is to allow connectors that support this to use the physical row identifier instead of the table's primary key.

      The primary benefit here is where tables have multiple columns forming the primary key. In oracle the generated query doesn't hit the index which causes incremental snapshots to be very slow.

              Unassigned Unassigned
              nathan-smit-1 Nathan Smit
              Nathan Smit
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated: