查询返回很慢，什么原因呢

[lailu]

一张表里记录太多，几百万条记录
我用odbc函数+sql语句 select top 100 ID from xx where ID not in (select top 100 from xx where Time<yy and Time>dd order by ID) and where Time<yy and Time>dd order by ID 实现类似的分页返回数据，表也做了ID和Time的聚集索引

结果是：查询日期越靠后越慢，sql server的内存占用也相当多
但是我直接在sql server的查询分析器中输入语句，查询结果反应很快，写应用程序中有什么优化吗

[WangZWang]

--语句改为如下:

Select top 100 ID
from (Select top 200 ID from xx where Time<yy and Time>dd order by ID) as t
order by ID desc

[snowmagic]

有not in，会很慢的

[gjz_1209]

将查询语句放入一存储过程中，会快很多。