返回信息流SELECT
COUNT(1)
FROM
(
SELECT
EACIA.CUS_ID
FROM
(
SELECT
CUS_ID
FROM
EMS_AFTER_CASE_INFO_ALL
WHERE
1 = 1
AND LAST_SPE_EXA_TIME >= STR_TO_DATE(
'2016-09-01 00:00:00',
'%Y-%m-%d %T'
)
AND LAST_SPE_EXA_TIME <= STR_TO_DATE(
'2016-09-01 23:59:59',
'%Y-%m-%d %T'
)
AND SPE_STATE NOT IN (
'after_SpeStatus_isCase',
'after_SpeStatus_isCaseEdit'
)
) EACIA
INNER JOIN (
SELECT
CUSTOMER_CODE,
NAME,
COLLECTION_DATE
ID,
SEGMENT_ID,
MOBILE
FROM
T_CUSTOMER
WHERE
1 = 1
) TC ON EACIA.CUS_ID = TC.ID
) T
WHERE
1 = 1
数据库是mysql,
EMS_AFTER_CASE_INFO_ALL,T_CUSTOMER 表有200w条数据
这是一条镜像帖。来源：北邮人论坛 / database / #10297同步于 2016/9/22
该镜像源已超过 30 天没有更新，可能在源站已被删除。
Database机器人发帖
[问题]下面这个sql改如何优化？
sky1990
2016/9/22镜像同步2 回复
订阅后，新回复会通过你的通知中心匿名送达。
2 条回复
SELECT
COUNT(EMS_AFTER_CASE_INFO_ALL.CUS_ID)
FROM
EMS_AFTER_CASE_INFO_ALL
INNER JOIN T_CUSTOMER
ON EMS_AFTER_CASE_INFO_ALL.CUS_ID = T_CUSTOMER.ID
WHERE
EMS_AFTER_CASE_INFO_ALL.LAST_SPE_EXA_TIME >= STR_TO_DATE(
'2016-09-01 00:00:00',
'%Y-%m-%d %T'
)
AND EMS_AFTER_CASE_INFO_ALL.LAST_SPE_EXA_TIME <= STR_TO_DATE(
'2016-09-01 23:59:59',
'%Y-%m-%d %T'
)
AND EMS_AFTER_CASE_INFO_ALL.SPE_STATE NOT IN (
'after_SpeStatus_isCase',
'after_SpeStatus_isCaseEdit'
);
没数据没法测