MV快速刷新时执行的SQL

MV快速执行时所涉及的比对SQL：[@more@]SELECT /*+ remote_mapped(SZPADB_CCADMIN) */
CURRENT$."MAPPING_FIELD_ID",
CURRENT$."TENANT_ID",
CURRENT$."FIELD_NAME",
CURRENT$."REMARK",
CURRENT$."CREATE_TIME",
CURRENT$."TABLE_NAME",
CURRENT$."RESERVE1",
CURRENT$."RESERVE2",
CURRENT$."FILE_UPLOAD_ID",
CURRENT$."CREATE_ID",
CURRENT$."CREATE_ORGAN_ID",
CURRENT$."EDIT_TIME",
CURRENT$."EDIT_ORGAN_ID",
CURRENT$."EDIT_ID",
CURRENT$."DATA_TYPE",
CURRENT$."EDIT_CODE",
CURRENT$."FIELD_LENGTH",
CURRENT$."FIELD_SHOW_NAME",
CURRENT$."INPUT_TYPE",
CURRENT$."IS_PHONE_NUMBER",
CURRENT$."CREATE_CODE",
CURRENT$."TEMP_FIELD_NAME",
CURRENT$."MAPPING_RULE_ID",
CURRENT$."IS_PASSWORD"
FROM (SELECT "CRM_FILE_MAPPING_FIELD"."MAPPING_FIELD_ID" "MAPPING_FIELD_ID",
"CRM_FILE_MAPPING_FIELD"."TENANT_ID" "TENANT_ID",
"CRM_FILE_MAPPING_FIELD"."FIELD_NAME" "FIELD_NAME",
"CRM_FILE_MAPPING_FIELD"."REMARK" "REMARK",
"CRM_FILE_MAPPING_FIELD"."CREATE_TIME" "CREATE_TIME",
"CRM_FILE_MAPPING_FIELD"."TABLE_NAME" "TABLE_NAME",
"CRM_FILE_MAPPING_FIELD"."RESERVE1" "RESERVE1",
"CRM_FILE_MAPPING_FIELD"."RESERVE2" "RESERVE2",
"CRM_FILE_MAPPING_FIELD"."FILE_UPLOAD_ID" "FILE_UPLOAD_ID",
"CRM_FILE_MAPPING_FIELD"."CREATE_ID" "CREATE_ID",
"CRM_FILE_MAPPING_FIELD"."CREATE_ORGAN_ID" "CREATE_ORGAN_ID",
"CRM_FILE_MAPPING_FIELD"."EDIT_TIME" "EDIT_TIME",
"CRM_FILE_MAPPING_FIELD"."EDIT_ORGAN_ID" "EDIT_ORGAN_ID",
"CRM_FILE_MAPPING_FIELD"."EDIT_ID" "EDIT_ID",
"CRM_FILE_MAPPING_FIELD"."DATA_TYPE" "DATA_TYPE",
"CRM_FILE_MAPPING_FIELD"."EDIT_CODE" "EDIT_CODE",
"CRM_FILE_MAPPING_FIELD"."FIELD_LENGTH" "FIELD_LENGTH",
"CRM_FILE_MAPPING_FIELD"."FIELD_SHOW_NAME" "FIELD_SHOW_NAME",
"CRM_FILE_MAPPING_FIELD"."INPUT_TYPE" "INPUT_TYPE",
"CRM_FILE_MAPPING_FIELD"."IS_PHONE_NUMBER" "IS_PHONE_NUMBER",
"CRM_FILE_MAPPING_FIELD"."CREATE_CODE" "CREATE_CODE",
"CRM_FILE_MAPPING_FIELD"."TEMP_FIELD_NAME" "TEMP_FIELD_NAME",
"CRM_FILE_MAPPING_FIELD"."MAPPING_RULE_ID" "MAPPING_RULE_ID",
"CRM_FILE_MAPPING_FIELD"."IS_PASSWORD" "IS_PASSWORD"
FROM "CRM_FILE_MAPPING_FIELD"@SZPADB_CCADMIN "CRM_FILE_MAPPING_FIELD") CURRENT$,
(SELECT DISTINCT MLOG$."MAPPING_FIELD_ID" "MAPPING_FIELD_ID"
FROM "CCADMIN"."MLOG$_CRM_FILE_MAPPING_FIE"@SZPADB_CCADMIN MLOG$
WHERE "SNAPTIME$$" > :1
AND ("DMLTYPE$$" != 'D')) LOG$
WHERE CURRENT$."MAPPING_FIELD_ID" = LOG$."MAPPING_FIELD_ID"

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10130206/viewspace-1043175/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10130206/viewspace-1043175/