问sql sever 查询超级慢，有大神帮忙优化一下吗？

SELECT STUFF

((SELECT ';' + Name

FROM BPMDB.dbo.YZAppAttachment

WHERE f.gongying_fujian LIKE '%' + FileID + '%' FOR XML PATH('')), 1, 1, '') AS swfujianming, STUFF

((SELECT ';' + FileID

FROM BPMDB.dbo.YZAppAttachment

WHERE f.gongying_fujian LIKE '%' + FileID + '%' FOR XML PATH('')), 1, 1, '') AS swfujianid, F.TaskID

FROM dbo.ZhaoCai_LuRu AS f, BPMDB.dbo.YZAppAttachment h

WHERE f.gongying_fujian LIKE '%' + h.FileID + '%'

GROUP BY f.gongying_fujian, F.TaskID