求救啊一个简单存储过程的查询速度优化?该怎么解决
日期：2014-05-18 浏览次数：20466 次
求救啊,一个简单存储过程的查询速度优化???
现在有一个存储过程查询,因为是查询中嵌套子查询,所以速度很慢,那为高手可以优化一下啊
存储过程如下:
CREATE PROCEDURE Sp_ClickAmTotal
@name char(10),
@rq char(10),
@count int OUTPUT
AS
select count(*) from
(select * from employee where hjbmbh in (select distinct
ShowDept from Dept where name=@name)) as E,
(select distinct kh COLLATE chinese_PRC_CI_AI as kh from kimkqdata
where rq=@rq and (hs1<11 or (hs1=11 and ms1<15))) as K
where E.kqkh=K.kh
------解决方案--------------------
现在有一个存储过程查询,因为是查询中嵌套子查询,所以速度很慢,那为高手可以优化一下啊
存储过程如下:
CREATE PROCEDURE Sp_ClickAmTotal
@name char(10),
@rq char(10),
@count int OUTPUT
AS
select count(*) from
(select * from employee where hjbmbh in (select distinct
ShowDept from Dept where name=@name)) as E,
(select distinct kh COLLATE chinese_PRC_CI_AI as kh from kimkqdata
where rq=@rq and (hs1<11 or (hs1=11 and ms1<15))) as K
where E.kqkh=K.kh
------解决方案--------------------
- SQL code
--try:
CREATE PROCEDURE Sp_ClickAmTotal
@name char(10),
@rq char(10),
@count int OUTPUT
AS
select count(1) from
(select kqkh from employee where exists(select 1
from Dept where ShowDept=hjbmbh and name=@name)) as E,
(select distinct kh COLLATE chinese_PRC_CI_AI as kh from kimkqdata
where rq=@rq and (hs1 <11 or (hs1=11 and ms1 <15))) as K
where E.kqkh=K.kh
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
