min(username) as 'username',min(CustomedSerstatus) as 'CustomedSerstatus',
GraphicsModel=stuff((select ','+GraphicsModel from GraphicsInfo where CustomedSer.CustomedSerID=GraphicsInfo.CustomedSerID for xml path('')),1,1,''),
min(CustomedSerupdatetime) as 'CustomedSerupdatetime',min(username) as 'username',sum(num) as TotalNum
from CustomedSer left join userinfo as u on CustomedSer.userid=u.userid
left join GraphicsInfo on CustomedSer.CustomedSerID=GraphicsInfo.CustomedSerID
group by CustomedSer.CustomedSerID, CustomedSer.userid,u.userapprovalid,u.usertype
order by CustomedSerstatus
这个代码段这行很快,为啥加了having之后就变慢了蛮多
select CustomedSer.CustomedSerID,CustomedSer.userid,min(CustomedSercreatetime) as 'CustomedSercreatetime',
min(username) as 'username',min(CustomedSerstatus) as 'CustomedSerstatus',
GraphicsModel=stuff((select ','+GraphicsModel from GraphicsInfo where CustomedSer.CustomedSerID=GraphicsInfo.CustomedSerID for xml path('')),1,1,''),
min(CustomedSerupdatetime) as 'CustomedSerupdatetime',min(username) as 'username',sum(num) as TotalNum
from CustomedSer left join userinfo as u on CustomedSer.userid=u.userid
left join GraphicsInfo on CustomedSer.CustomedSerID=GraphicsInfo.CustomedSerID
group by CustomedSer.CustomedSerID, CustomedSer.userid,u.userapprovalid,u.usertype
having u.userapprovalid=72 and u.usertype='Service'
order by CustomedSerstatus
变慢了,才几千条数据,结果集也就一千多条耗时15秒