语句1:
select * from t_data where
id in
(select top 10 id from t_data where id in
(select top 60000 id from t_data order by id asc)
order by id desc)
order by id asc
时间:390ms
语句2:
select * from t_data where
id in
(select top 10 id from t_data where id in
(select top 100000 id from t_data order by id asc)
order by id desc)
order by id asc
时间:4s
语句3:
select * from t_data where
id in
(select top 10 id from t_data where id in
(select top 150000 id from t_data order by id asc)
order by id desc)
order by id asc
时间:5s
语句4:
select * from t_data where
id in
(select top 10 id from t_data where id in
(select top 200000 id from t_data order by id asc)
order by id desc)
order by id asc
时间:6s
语句5:
select * from t_data where
id in
(select top 10 id from t_data where id in
(select top 250000 id from t_data order by id asc)
order by id desc)
order by id asc
时间:过了15m没有出来,中断
语句6:
select * from t_data where
id in
(select top 10 id from t_data where id in
(select top 300000 id from t_data order by id asc)
order by id desc)
order by id asc
时间:过了20m没有出来,中断
语句7:
select top 60000 id into #a from t_data order by id asc
create index ind_a_base_id on #a(id)
select * from t_data where
id in (select top 10 id from #a order by id desc)
order by id asc
时间:20s
语句8:
select top 100000 id into #a from t_data order by id asc
create index ind_a_base_id on #a(id)
select * from t_data where
id in (select top 10 id from #a order by id desc)
order by id asc
时间:21s
语句9:
select top 150000 id into #a from t_data order by id asc
create index ind_a_base_id on #a(id)
select * from t_data where
id in (select top 10 id from #a order by id desc)
order by id asc
时间:23s
语句10:
select top 200000 id into #a from t_data order by id asc
create index ind_a_base_id on #a(id)
select * from t_data where
id in (select top 10 id from #a order by id desc)
order by id asc
时间:24s
语句11:
select top 250000 id into #a from t_data order by id asc
create index ind_a_base_id on #a(id)
select * from t_data where
id in (select top 10 id from #a order by id desc)
order by id asc
时间:26s
语句12:
select top 300000 id into #a from t_data order by id asc
create index ind_a_base_id on #a(id)
select * from t_data where
id in (select top 10 id from #a order by id desc)
order by id asc
时间:28s
语句13:
select top 400000 id into #a from t_data order by id asc
create index ind_a_base_id on #a(id)
select * from t_data where
id in (select top 10 id from #a order by id desc)
order by id asc
时间:29s
语句14:
select * from t_data where
id in
(select top 10 id from t_data where id in
(select top 250000 id from t_data order by id asc)
order by id desc)
order by id asc