You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@flink.apache.org by "tianfy (Jira)" <ji...@apache.org> on 2026/06/04 07:10:00 UTC

[jira] [Created] (FLINK-39841) Add an option to skip Oracle ANALYZE TABLE before incremental snapshot chunk planning

tianfy created FLINK-39841:
------------------------------

             Summary: Add an option to skip Oracle ANALYZE TABLE before incremental snapshot chunk planning
                 Key: FLINK-39841
                 URL: https://issues.apache.org/jira/browse/FLINK-39841
             Project: Flink
          Issue Type: Improvement
          Components: Flink CDC
            Reporter: tianfy


Oracle CDC currently executes ANALYZE TABLE before querying ALL_TABLES.NUM_ROWS for approximate row count during incremental snapshot chunk planning.

For large Oracle tables this can be expensive, require additional privileges, and delay job startup. Users should be able to opt out when stale approximate row counts are acceptable or when ANALYZE TABLE cannot be executed in the production environment.

Expected behavior:
* add an Oracle CDC table/source option to control whether ANALYZE TABLE is executed
* keep the current behavior enabled by default
* when disabled, skip ANALYZE TABLE and continue to use ALL_TABLES.NUM_ROWS for approximate row count



--
This message was sent by Atlassian Jira
(v8.20.10#820010)