您的位置：程序门 -> ms-sql server -> 基础类

求一语句的优化写法

[收藏此页] [打印本页]选择字色：背景色：字体：[大][中][小]

求一语句的优化写法[已结贴,结贴人:jiaojian843]

发表于：2007-01-18 09:43:04 楼主

select ... from logisticsproject,projectbatch where
logisticsproject.mainkey = projectbatch.projectkey and logisticsproject.projecttypeid= '值 ' and
projectbatch.projectbatchid= '值 ' and ... and
projectbatch.mainkey in
（select projectbatchkey from feedetail where ratifyid = '1 ' and transaccountid = '0 ')
　
此处查询速度有点慢，请各位给优化一下提高下查询速度。

发表于：2007-01-18 09:51:281楼得分:15

select ... from logisticsproject,projectbatch,feedetail where
logisticsproject.mainkey = projectbatch.projectkey and logisticsproject.projecttypeid= '值 ' and
projectbatch.projectbatchid= '值 ' and ... and
projectbatch.mainkey = feedetail.projectbatchkey
and feedetail.ratifyid = '1 ' and feedetail.transaccountid = '0 '

发表于：2007-01-18 10:01:142楼得分:10

用in的话确实会慢一些

发表于：2007-01-18 10:07:093楼得分:15

--try

select ...
from logisticsproject, projectbatch
where
logisticsproject.mainkey = projectbatch.projectkey and
logisticsproject.projecttypeid= '值 ' and
projectbatch.projectbatchid= '值 ' and ... and
projectbatch.mainkey in
（select distinct projectbatchkey from feedetail where ratifyid = '1 ' and transaccountid = '0 ')

发表于：2007-01-18 10:21:014楼得分:10

select ...
from logisticsproject
inner join projectbatch on logisticsproject.mainkey = projectbatch.projectkey and
logisticsproject.projecttypeid= '值 ' and projectbatch.projectbatchid= '值 ' and ...
inner join feedetail on projectbatchkey = projectbatch.mainkey and ratifyid = '1 ' and transaccountid = '0 '

然后该建index的就建index

其他资讯