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

Improve LogMiner query performance by reducing REGEXP_LIKE disjunctions

XMLWordPrintable

      The Oracle connector presently takes every schema and table include value and builds a REGEXP_LIKE predicate for each entry. This can lead to poor performance when a large number of tables or schemas are being specified. We should look to build this expression using a singular REGEXP_LIKE predicate for schema include/excludes and one for table include/excludes or pulling this logic into the connector's Java code for better performance.

              ccranfor@redhat.com Chris Cranford
              ccranfor@redhat.com Chris Cranford
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: