SqlServer查询性能优化

[寒暄]

select 更新日志ID AS ID,工点ID,更新日期4 As 创建时间,(项目名称+
CASE WHEN 标段名称 IS NULL
THEN ' - '
ELSE (' - '+标段名称+' - ')
END +工点名称 +' 日期：'+convert(varchar(10), 更新日期4))as StyleTitle
,('创建人：'+用户4+CHAR(13)+'创建时间：'+convert(varchar(10), 更新日期4)) as tooltip
from viw_工点更新日志 WHERE (更新日期4 IS NOT NULL) and 用户4 not in (select UID from 测试用户表)
and 工点ID in (194,113,188,177,85,83,193,197,176,179,181,200,165,164,180,185,172,199,184,171,198,167,192,183,170,196,175,166,191,169,187,174,182,168,195,186,189) ORDER BY isnull(更新日期4,'') DESC


sql语句还能怎样优化，发布到到外网上进行查询几乎要花3到4分钟才能显示出数据来。

[「已注销」]

空间换取时间

[yzf86211861]

not in 是否可以 换成 not exists.

[编程思想]

not in
in
两个语句数据量大的话很影响效率的，想办法用变通的方法避免使用

[laowang134]

用户4 not in (select UID from 测试用户表)-->
not exists (select 1 from 测试用户表 where uid=viw_工点更新日志.用户4)