视图的SQL语句
SELECT
T1.BUSINESS_DATE,
T1.BUSINESS_ID,
T2.ENTERPRISE_NAME,
T1.ENTERPRISE_Q AS PERMISSION,
IFNULL(T1.TOTAL_ORDER,0) TOTAL_ORDER,
IFNULL(T1.TOTAL_CAR_COMPLIANCE_ORDER,0) TOTAL_CAR_COMPLIANCE_ORDER,
IFNULL(T1.TOTAL_DRIVER_COMPLIANCE_ORDER,0) TOTAL_DRIVER_COMPLIANCE_ORDER,
IFNULL(T1.TOTAL_ALL_COMPLIANCE_ORDER,0) TOTAL_ALL_COMPLIANCE_ORDER,
IFNULL(T3.VEHICLE_ORDER_COUNT,0) VEHICLE_ORDER_COUNT,
IFNULL(T3.VEHICLE_COMPLIANCE_COUNT,0) VEHICLE_COMPLIANCE_COUNT,
IFNULL(T3.VEHICLE_NO_COMPLIANCE_COUNT,0) VEHICLE_NO_COMPLIANCE_COUNT,
IFNULL(T4.DRIVER_ORDER_COUNT,0) DRIVER_ORDER_COUNT,
IFNULL(T4.DRIVER_COMPLIANCE_COUNT,0) DRIVER_COMPLIANCE_COUNT,
IFNULL(T4.DRIVER_NO_COMPLIANCE_COUNT,0) DRIVER_NO_COMPLIANCE_COUNT
FROM
RF_STATISTICAL.DWS_WY_ORDER_STATISTICS_ENTERPRISE_DAY AS T1
LEFT JOIN RF_GOVAFFAIR.T_WY_DEPT_ENTERPRISE AS T2 ON T1.BUSINESS_ID = T2.COMPANY_ID
LEFT JOIN (SELECT
COMPANY_ID,
BUSINESS_DATE,
COUNT(BUSINESS_ID) AS VEHICLE_ORDER_COUNT,
SUM(case when VEHICLE_Q = 'yes' then 1 else 0 end) VEHICLE_COMPLIANCE_COUNT,
SUM(case when VEHICLE_Q = 'no' then 1 else 0 end) VEHICLE_NO_COMPLIANCE_COUNT
FROM RF_STATISTICAL.DWS_WY_ORDER_STATISTICS_VEHICLE_DAY
GROUP BY BUSINESS_DATE, COMPANY_ID) AS T3 ON T1.BUSINESS_DATE = T3.BUSINESS_DATE AND T1.BUSINESS_ID = T3.COMPANY_ID
LEFT JOIN (SELECT
COMPANY_ID,
BUSINESS_DATE,
COUNT(BUSINESS_ID) AS DRIVER_ORDER_COUNT,
SUM(case when DRIVER_Q = 'yes' then 1 else 0 end) DRIVER_COMPLIANCE_COUNT,
SUM(case when DRIVER_Q = 'no' then 1 else 0 end) DRIVER_NO_COMPLIANCE_COUNT
FROM RF_STATISTICAL.DWS_WY_ORDER_STATISTICS_DRIVER_DAY
GROUP BY BUSINESS_DATE, COMPANY_ID) AS T4 ON T1.BUSINESS_DATE = T4.BUSINESS_DATE AND T1.BUSINESS_ID = T4.COMPANY_ID

看下两个SQL的执行计划
下面执行快的是直接带入值的方式，不是绑定变量也就是? 问号的形式。
直接在管理工具执行原始SQL，然后在弹出的输入框里面输入两个参数的值，对比下执行时间和执行计划。
也有可能是表统计信息不准导致。