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

      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

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

              Dates

              Created:
              Updated:
              Resolved: