SQL 40W的数据记录 关联2个表 一个查询用了 动不动就2分钟 大家帮我看看 效率太低了

[ldwz]

select top 1000 R_Person.jobid,R_Person.name, R_Person.xingbie,R_Person.birthyear, R_Person.xueli, R_Person.phototre,R_Person.zcdate, R_Person.City,R_Person.dlsj,R_Quanzhi.selectedjob1,R_Quanzhi.selectedjob2,R_Quanzhi.selectedjob3,R_Person.pingjia,R_Person.jingyanshuoming FROM R_Quanzhi INNER JOIN R_Person ON R_Quanzhi.jobid = R_Person.jobid where datediff(d,xgsj,getdate()) < 90 and jlbm=0 order by dlsj desc





select top 1000
R_Person.jobid,
R_Person.name,
R_Person.xingbie,
R_Person.birthyear,
R_Person.xueli,
R_Person.phototre,
R_Person.zcdate,
R_Person.City,R_Person.dlsj,
R_Quanzhi.selectedjob1,
R_Quanzhi.selectedjob2,
R_Quanzhi.selectedjob3,
R_Person.pingjia,
R_Person.jingyanshuoming
FROM R_Quanzhi INNER JOIN R_Person ON R_Quanzhi.jobid = R_Person.jobid
where datediff(d,xgsj,getdate()) < 90 and jlbm=0 order by dlsj desc


为了方便大家看我把 语句 分割开了！！




就这个记录 用1。58分钟 数据库还是本机！

我自己写了个存储过程
程序调用
set cmdexample=server.createobject("adodb.command")
cmdexample.activeconnection=conn
cmdexample.commandtext="aa"
cmdexample.commandtype=4
cmdexample.parameters("@SS").value=trim(session("SiteID")
set rs=cmdexample.execute


存储过程
create proc aa
@ss int
as
select top 1000 R_Person.jobid,R_Person.name, R_Person.xingbie,R_Person.birthyear, R_Person.xueli, R_Person.phototre,R_Person.zcdate, R_Person.City,R_Person.dlsj,R_Quanzhi.selectedjob1,R_Quanzhi.selectedjob2,R_Quanzhi.selectedjob3,R_Person.pingjia,R_Person.jingyanshuoming FROM R_Quanzhi INNER JOIN R_Person ON R_Quanzhi.jobid = R_Person.jobid where datediff(d,xgsj,getdate()) < @ss and R_Person.jlbm=0 order by R_Person.dlsj desc
GO

也慢的不行！！！我第一次搞怎么大的数据！！1大家告诉我怎么优化呀！！！！汗！

[leohuang]

把top 1000 去了看快不

[lystart]

建立索引了没有?

[ldwz]

没建立索引。。不会建 ，没建过。。。

TOP 1000 去掉后。应该更慢吧！！
如何建立索引？？

[ldwz]

TTTTT 郁闷
2天拉。。一直拖者。。

[ldwz]

我顶你个肺

[oomen]

去order by dlsj desc 这个呢

[ldwz]

我测试一哈！

[ldwz]

我晕！ order by dlsj desc 去掉就快多了。怎么在索引里面让他排序！