sr使用jdbc外表的方式查询达梦数据库表，查询效率变慢 例如：select * from 表名 where 字段名 in （子查询）

[Qinghan25]

Enhancement

--建立external 资源，
CREATE EXTERNAL RESOURCE EXTjdbcdm4
PROPERTIES (
"type" = "jdbc",
"user" = "XXX",
"password" = "XXXX",
"jdbc_uri" = "jdbc:dm://XXXX:5236/XXX",
"driver_url" = "file:///home/rim/DmJdbcDriver18-8.1.1.193.jar",
"driver_class" = "dm.jdbc.driver.DmDriver"
);
建立外表：
create external table jdbc_tbl7(
INDI_ID VARCHAR(20) NULL,
INDI_NAME VARCHAR(255) NULL,
CLASSIFY_ID VARCHAR(20) NULL,
INDI_COMMENT VARCHAR(255) NULL,
INDI_TYPE VARCHAR(20) NULL,
INCLUDE_CHILD VARCHAR(2) NULL
)
ENGINE=jdbc
PROPERTIES (
"resource" = "EXTjdbcdm4",
"table" = "XXXXX.xxxI"
);