sql一直执行中,已经24分钟了。。。。
贴上代码,请教下各位有木有可以优化的地方
select d.AppO_Title as AppoTitle,d.App_Time as AppTime,c.AppD_Name as AppDName,
f.UserID as UserID,f.UserName as UserName, e.Creator as Creater,
(select users.UserName from users where users.UserID = e.Creator) as StartMan,
e.Started_Date,12 as StandardTime,
dbo.fn_AppHourOfTwoDatesNew(d.App_BeginTime,CASE WHEN (d.App_Time is null) THEN ('11 21 2016 4:54PM') ELSE (d.App_Time) END) as PersonalTime,
(Convert(int,(dbo.fn_AppHourOfTwoDatesNew(d.App_BeginTime,CASE WHEN (d.App_Time is null) THEN ('11 21 2016 4:54PM') ELSE (d.App_Time) END))) - 12) as NodeOverTime
from JHOA_Approve d
inner join JHOA_Approve_Instance e on d.Instance_ID = e.Instance_ID and e.status != 'deleted' and e.template_id = d.appt_id
inner join JHOA_APPROVE_Template b on b.TEM_ID='14720b6a675d4cee9250cba0c687f54a'
inner join JHOA_APPROVE_Temp_Type a on b.TEM_TypeID = a.ID and a.status='active'
inner join (select aa.appd_id,aa.appd_name,bb.instance_id from JHOA_Approve_temp_Dispose aa inner join jhoa_approve_instance bb on aa.appd_id =1953 and aa.appt_id = bb.template_ID and aa.version=bb.version) c on d.AppD_ID = c.AppD_ID
inner join users f on CASE WHEN (d.App_DeputyCode IS null) then (d.reg_code) ELSE (d.App_DeputyCode) END = f.UserID
where d.Del_Flag = 0 and d.appt_id = '14720b6a675d4cee9250cba0c687f54a' and d.AppD_ID = '1953'and d.App_Time >= '2016-11-01' and d.App_State = 0 and d.App_State = 0 and d.App_Time <= '2016-11-21 23:59:59'group by d.AppO_Title,d.App_Time,c.AppD_Name,f.UserID,f.UserName,e.Creator,e.Started_Date,d.App_BeginTime