太长了..scrollbar拉来拉去都晕了.是索引的选择差异导致了不一样的效果.因为不知道你表上的索引情况,你先这样试试吧。select top 40 * from ( SELECT uid,u.unicknme,uname,Uclass,Uaddr,Utel,Uemail,user_regtime,comname,cgxq,Shzt,q.re FROM userinfo as u with (index=IX_userinfo_Unicknme_yn) inner join Q_Basicinfo q on q.unicknme = u.unicknme WHERE u.yn=1 and u.showid=1 and q.yn=1 and q.shzt<>'2' ) t ORDER BY uid DESC
SELECT uid,u.unicknme,uname,Uclass,Uaddr,Utel,Uemail,user_regtime,comname,cgxq,Shzt,q.re
FROM userinfo as u with (index=IX_userinfo_Unicknme_yn) inner join Q_Basicinfo q on q.unicknme = u.unicknme
WHERE u.yn=1 and u.showid=1
and q.yn=1 and q.shzt<>'2' ) t
ORDER BY uid DESC
第二次是因为没有物理读的原因吗? 尝试着去掉缓存看看~set statistics io on看看~