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

Table scan is performed anyway even if snapshot.mode is set to initial_schema_only

    Details

      Description

      If snapshot.mode is set to initial_schema_only, a full table scan is not required, as with big table it can a take a lot of time and resources. A TOP (0) or TOP (1) should be added to the SELECT statement in order to return only 0 or 1 row.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                jpechanec Jiri Pechanec
                Reporter:
                davide.mauri Davide Mauri
                Tester:
                Davide Mauri
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: