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)
