这sql如何优化
日期：2014-05-16 浏览次数：20512 次
这sql怎么优化啊
View_UserMessage是一个视图，试图脚本如下
SELECT a.Info_ID
,a.info_Status
,b.status_Name
,a.Info_Regional
,a.Info_ReleaseTime
,a.Info_ContractNO
,a.Info_CustomerName
,a.Info_CustomerContacts
,a.Info_CustomerTel
,a.Info_ContractAmount
,a.Info_ISUserID
,c.Sys_UserName as Info_ISUserName
,a.Info_ISUserDeptID
,c.Sys_Dept as Info_ISUserDept
,a.Info_ISUserDeptGroupID
,c.Sys_DeptGroup as Info_ISUserDeptGroup
,a.Info_MangerUID
,d.Sys_UserName as Info_MangerName
,a.Info_MangerUserDeptID
,d.Sys_Dept as Info_MangerDept
,a.Info_MangerDeptGroupID
,d.Sys_DeptGroup as Info_MangerDeptGroup
,a.Info_OSAssistantUID
,e.Sys_UserName as Info_OSAssistantName
,a.Info_OSAssistantDeptID
,e.Sys_Dept as Info_OSAssistantDept
,a.Info_OSAssistantDeptGroupID
,e.Sys_DeptGroup as Info_OSAssistantDeptGroup
,a.Info_OSUserID
,f.Sys_UserName as Info_OSUserName
,a.Info_OSUserDeptID
,f.Sys_Dept as Info_OSUserDept
,a.Info_OSUserDeptGroupID
,f.Sys_DeptGroup as Info_OSUserDeptGroup
,a.Info_IdentifyingCode
FROM NCC_Info a
inner join NCC_ContractStatus b
on a.info_Status=b.status_ID
left join View_UserMessage c
on a.Info_ISUserID=c.Sys_UserID
left join View_UserMessage d
on a.Info_MangerUID=d.Sys_UserID
left join View_UserMessage e
on a.Info_OSAssistantUID=d.Sys_UserID
left join View_UserMessage f
on a.Info_OSUserID=d.Sys_UserID
View_UserMessage是一个视图，试图脚本如下
SELECT a.Sys_UserID, b.Sys_Dept, c.Sys_DeptGroup, a.Sys_UserName
FROM Sys_User AS a LEFT JOIN
&n
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
