为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:
【操作系统】：
【CPU】:
【问题描述】*：dm7

select
a.id ,
a.LIST_ID as listId,
a.POWER,
a.FDDYNAME as dyName ,
a.FDDYID as dyId,
a.MARK ,
a.jypdate,
c.pdate,
a.CREATEDATE ,
b.SCREENNAME as username,
c.PERIOD_ID periodId
from
NMJY.T_JYGL_JYLC_MONTHLY_DELIST_PERSIST(160万行) a
left join NMJY.t_security_user（8千行） b on a.CREATOR = b.USERID
left join NMJY.T_JYGL_JYLC_MONTHLY_OBJECT_CURVE_PERSIST（3000万行） c on a.list_id = c.id
where
a.SEQID = ? and a.DELIST_TYPE = '1'
and a.JYPDATE = ? and a.FDDYID in (select DISTINCT t.FDDYID from
NMJY.t_bas_fddy t
where t.ISENABLE = '1' and t.PLANTID = ? ) order by a.CREATEDATE