先看结论
能力矩阵暂未声明该特征,按未覆盖处理并降低置信度,建议 PoC 复核
改写
需按命中位置逐条评估改写
库侧 / 应用侧
需人工确认改造边界
需人工确认改造边界
验证建议:全表 UPDATE 在迁移压测中单独评估锁等待、redo/事务日志和回滚窗口;确认是否确为批处理意图。
参考来源
- https://help.kingbase.com.cn/v8/development/sql-plsql/sql/index.html
- https://bbs.kingbase.com.cn/kingbase-doc/v9/development/sql-plsql/index.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/SELECT.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/UPDATE.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DELETE.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Joins.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/optimizer-access-paths.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Literals.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Data-Type-Comparison-Rules.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/IN-Condition.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Logical-Conditions.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Pattern-matching-Conditions.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ROWNUM-Pseudocolumn.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/NVL.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Scalar-Subquery-Expressions.html