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

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 0.10.0.Beta4
    • 0.9.5.Final, 0.10.0.Beta3
    • sqlserver-connector
    • None

    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.

      Attachments

        Activity

          People

            jpechane Jiri Pechanec
            davide.mauri Davide Mauri (Inactive)
            Davide Mauri Davide Mauri (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: