以下的贴子怎么没了?因为我有重大发现!(接b615n (周围走) )
没办法,CSDN不给我连续回答3次 ;-)大家接着来吧
=================================================================
Test 5,耗时12s/11s/12s:
select * from dbo.T1 where
id in
(select top 10 id from dbo.T1 where id in
(select top 1000000 id from dbo.T1 order by id asc)
order by id desc)
order by id asc
Test 6,耗时12s/12s/11s:
SELECT *
FROM dbo.T1 INNER JOIN
(SELECT TOP 10 id
FROM dbo.T1
WHERE id IN
(SELECT TOP 1000000 id
FROM dbo.T1
ORDER BY id ASC)
ORDER BY id DESC) a ON dbo.T1.id = a.id
ORDER BY 1
按照那位贴主写得,测试了一下100万的,依然没有发现有什么区别,他那么好的机器,还那么慢,一定是配置或者Index上有问题,真有点暴物天珍,改天有空我在那台2CPU的Server上试试