SELECT
d.JG_MC,
d.JG_DM,
- count(a.id) A00,
a.FPLX
FROM
fp_kjxx a,
dm_kf b,
xt_logintime c,
dm_jg d
WHERE
a.KFBM = b.KF_DM
AND c.yzdm = a.YZDM
AND d.JG_DM = a.YZDM
AND a.kpsj >= c.logintime
GROUP BY
d.JG_MC,
d.JG_DM,
a.FPLXfp_kjxx 这个表数据大查询很慢,听老师傅说要做etl,不太会整,大牛们还有啥别的方法.
d.JG_MC,
d.JG_DM,
- count(a.id) A00,
a.FPLX
FROM
fp_kjxx a,
dm_kf b,
xt_logintime c,
dm_jg d
WHERE
a.KFBM = b.KF_DM
AND c.yzdm = a.YZDM
AND d.JG_DM = a.YZDM
AND a.kpsj >= c.logintime
GROUP BY
d.JG_MC,
d.JG_DM,
a.FPLXfp_kjxx 这个表数据大查询很慢,听老师傅说要做etl,不太会整,大牛们还有啥别的方法.
explain select ...
show index from ..
以供分析。