公用表表达式（CTE）对SQL语句执行效率的影响。

#源代码1：
select t.*, t.data_resource MAT_CLASS
from (SELECT A.data_resource, A.MAT_CODE, A.COMPANY_CODE
FROM XGIRP1.TYMIR22 A
WHERE A.COMPANY_CODE = ‘XISC’
and A.data_resource like ‘%条码打印%’
UNION
SELECT DISTINCT B.MAT_CLASS, B.MAT_CODE, B.COMPANY_CODE
FROM XGIRP1.TQMIR0A B
WHERE B.MAT_CODE != ’ ') t
WHERE t.MAT_CODE IN
(select mat_code
from (SELECT A1.data_resource, A1.MAT_CODE, A1.COMPANY_CODE
FROM XGIRP1.TYMIR22 A1
WHERE A1.COMPANY_CODE = ‘XISC’
and A1.data_resource like ‘%条码打印%’
UNION
SELECT DISTINCT B1.MAT_CLASS, B1.MAT_CODE, B1.COMPANY_CODE
FROM XGIRP1.TQMIR0A B1
WHERE B1.MAT_CODE != ’ ') t1
group by t1.mat_code
having count(t1.mat_code) > 1)
AND t.COMPANY_CODE = ‘XISC’
执行时间：service end. 1136ms elapsed.时间1s多。
#源代码2：
WITH temp AS
(SELECT A.data_resource, A.MAT_CODE, A.COMPANY_