sql嵌套查询有bug吗?

[xjchen]

select top 40 * from view_sell_search where xinghao like 'rt9161%' and
id not in(select top 40 id from view_sell_search where xinghao like 'aaaaa%' order by grade desc,flashtime desc)
order by grade desc,flashtime desc

一段分页 采用id not in 的方法，可发现查询运行死在那里出不来了.
但如果把最先40条的id 直接写入 not in 里马上可以出来. 运行
select top 40 id from view_sell_search where xinghao like 'aaaaa%' order by grade desc,flashtime desc 也很快. 怎么回事?
另外 aaaaa如果换成其他的如bbbbbb 也能很快出来,而且符合bbbbbb的记录还要更多.

[zicxc]

view_sell_search 是视图吧

sql试图优化，但是在考虑视图，连接条件等进行的优化的结果效率很成问题

估计很难改

[zicxc]

可以用临时表
select top 40 id into #t from view_sell_search where xinghao like 'aaaaa%' order by grade desc,flashtime desc

select top 40 * from view_sell_search where xinghao like 'rt9161%' and
id not in(select id from #t)
order by grade desc,flashtime desc