请问以下Sql语句该怎么优化才好?
select OServerProcessUID,ServerProcessName,
ServerProcessID,PublicIP,PublicPort,PrivateIP,PrivatePort,OServerProcessBusinessTypeID,
ServerProcessTypeID,DeviceOnlineCount,DeviceConnectionCount,SoftwareVerNo,IsEnabled,DelFlag,
Description,CreateIP,CreateTime,ModifyIp,ModifyTime
FROM OServerProcess
where 1=1 and IsEnabled=1 and DelFlag=0
and OServerProcessUID in
(select OServerProcessUID from OServerProcessVSProcessGroup where IsEnabled=1 and
DelFlag=0 and OServerProcessGroupUID
in (select OServerProcessGroupUID from ODeviceGroupVSProcessGroup where IsEnabled=1 and
DelFlag=0 and DeviceGroupUID in (select DeviceGroupUID from dbo.ODeviceVSGroup
where 1=1 and IsEnabled=1 and DelFlag=0 and
DeviceUID in ( '82cf5852-45cf-e211-8c19-00163e0071c8'))))还有,那个sql执行计划怎么看?SQL优化 执行计划
select OServerProcessUID,ServerProcessName,
ServerProcessID,PublicIP,PublicPort,PrivateIP,PrivatePort,OServerProcessBusinessTypeID,
ServerProcessTypeID,DeviceOnlineCount,DeviceConnectionCount,SoftwareVerNo,IsEnabled,DelFlag,
Description,CreateIP,CreateTime,ModifyIp,ModifyTime
FROM OServerProcess
where 1=1 and IsEnabled=1 and DelFlag=0
and OServerProcessUID in
(select OServerProcessUID from OServerProcessVSProcessGroup where IsEnabled=1 and
DelFlag=0 and OServerProcessGroupUID
in (select OServerProcessGroupUID from ODeviceGroupVSProcessGroup where IsEnabled=1 and
DelFlag=0 and DeviceGroupUID in (select DeviceGroupUID from dbo.ODeviceVSGroup
where 1=1 and IsEnabled=1 and DelFlag=0 and
DeviceUID in ( '82cf5852-45cf-e211-8c19-00163e0071c8'))))还有,那个sql执行计划怎么看?SQL优化 执行计划
解决方案 »
- 求一個排序方法,兩個時間,用最小的排序
- Sql Server 存储图像数据能不能存储压缩格式的啊?
- 老大们 999999 速度9M...
- 为什么.运用内存.剧烈会高.
- 我要建一個與已經存在的表相同字段的臨時表,這兩種方法哪一個好
- 求助!紧急啊~~查询条件为空的时候略过,不为空是判断,不为空时的查询语句怎么加判断条件!!!
- 怎么修改.ldf的名称
- 利用BCP把一个文本文件中的数据导入到数据库中,可以把文本文件中的数据追加到表中么?
- 我想学ASP+SQLServer,但不知Asp+,SQLServer2000与Asp3,Sqlserver7的差别大么?
- 奇葩问题一个……求助
- 关于一个考勤问题的查询。
- 关于sql server临时表的问题
不知道怎么看的百度一下
SELECT OServerProcessGroupUID
INTO #t1
FROM ODeviceGroupVSProcessGroup
WHERE IsEnabled = 1
AND DelFlag = 0
AND DeviceGroupUID IN (SELECT DeviceGroupUID
FROM dbo.ODeviceVSGroup
WHERE 1 = 1
AND IsEnabled = 1
AND DelFlag = 0
AND DeviceUID IN ('82cf5852-45cf-e211-8c19-00163e0071c8')) SELECT OServerProcessUID
INTO #t2
FROM OServerProcessVSProcessGroup
WHERE IsEnabled = 1
AND DelFlag = 0
AND OServerProcessGroupUID IN (SELECT OServerProcessGroupUID
FROM #t1)
SELECT OServerProcessUID , ServerProcessName , ServerProcessID , PublicIP , PublicPort , PrivateIP , PrivatePort , OServerProcessBusinessTypeID ,
ServerProcessTypeID , DeviceOnlineCount , DeviceConnectionCount , SoftwareVerNo , IsEnabled , DelFlag , Description , CreateIP , CreateTime , ModifyIp ,
ModifyTime
FROM OServerProcess
WHERE 1 = 1
AND IsEnabled = 1
AND DelFlag = 0
AND OServerProcessUID IN ( SELECT OServerProcessUID FROM #t2 )
ServerProcessID,PublicIP,PublicPort,PrivateIP,PrivatePort,OServerProcessBusinessTypeID,
ServerProcessTypeID,DeviceOnlineCount,DeviceConnectionCount,SoftwareVerNo,IsEnabled,DelFlag,
Description,CreateIP,CreateTime,ModifyIp,ModifyTime
FROM OServerProcess a
inner join OServerProcessVSProcessGroup b on a.OServerProcessUID=b.OServerProcessUID and b. IsEnabled=1 and b.DelFlag=0
inner join ODeviceVSGroup c on b.DeviceGroupUID=c.DeviceGroupUID and c.IsEnabled=1 and c.DelFlag=0 and c.DeviceUID='82cf5852-45cf-e211-8c19-00163e0071c8'
where a.IsEnabled=1 and a.DelFlag=0
这个我已经想出来了!
继续等待更优化的