生产库数据量比开发库大很多吗? 考虑加索引优化SQL, 试试: with LIST1 as (SELECT WCADMIN.T_ISSUE_INFO.C_NUMBER FROM WCADMIN.T_PROJECT_INFO INNER JOIN WCADMIN.T_ISSUE_INFO ON WCADMIN.T_PROJECT_INFO.C_NAME = WCADMIN.T_ISSUE_INFO.C_CONTEXT WHERE WCADMIN.T_PROJECT_INFO.C_NAME='MTW_Paris'), LIST2 as (SELECT C_ISSUE_NUMBER AS C_ISSUE_NUMBER03,C_IBA_VALUE AS C_IBA_VALUE001 FROM T_ISSUE_IBA WHERE C_IBA_NAME='METAL_NPI_MMMME'), LIST3 AS (SELECT C_ISSUE_NUMBER AS C_ISSUE_NUMBER03,C_IBA_VALUE AS C_IBA_VALUE002 FROM T_ISSUE_IBA WHERE C_IBA_NAME='METAL_NPI_WORK_COMPLETE_RATE') SELECT count(*) AS A1 FROM ( SELECT C_IBA_VALUE001 FROM LIST1 LEFT JOIN LIST2 ON LIST1.C_NUMBER=LIST2.C_ISSUE_NUMBER03 LEFT JOIN LIST3 ON LIST1.C_NUMBER=LIST3.C_ISSUE_NUMBER03 )listtb WHERE C_IBA_VALUE001 LIKE '%人%' OR C_IBA_VALUE001 LIKE '%Man%'
考虑加索引优化SQL,
试试:
with LIST1 as (SELECT WCADMIN.T_ISSUE_INFO.C_NUMBER FROM WCADMIN.T_PROJECT_INFO INNER JOIN WCADMIN.T_ISSUE_INFO ON WCADMIN.T_PROJECT_INFO.C_NAME = WCADMIN.T_ISSUE_INFO.C_CONTEXT WHERE WCADMIN.T_PROJECT_INFO.C_NAME='MTW_Paris'),
LIST2 as (SELECT C_ISSUE_NUMBER AS C_ISSUE_NUMBER03,C_IBA_VALUE AS C_IBA_VALUE001 FROM T_ISSUE_IBA WHERE C_IBA_NAME='METAL_NPI_MMMME'),
LIST3 AS (SELECT C_ISSUE_NUMBER AS C_ISSUE_NUMBER03,C_IBA_VALUE AS C_IBA_VALUE002 FROM T_ISSUE_IBA WHERE C_IBA_NAME='METAL_NPI_WORK_COMPLETE_RATE')
SELECT count(*) AS A1 FROM ( SELECT C_IBA_VALUE001 FROM
LIST1 LEFT JOIN LIST2 ON LIST1.C_NUMBER=LIST2.C_ISSUE_NUMBER03 LEFT JOIN LIST3 ON LIST1.C_NUMBER=LIST3.C_ISSUE_NUMBER03 )listtb WHERE C_IBA_VALUE001 LIKE '%人%' OR C_IBA_VALUE001 LIKE '%Man%'