本人推荐一个方法:
找个里面有超过1000万(越多越好,最好没有索引)条记录的数据表,然后用
select top 100 * from table
select top 100 * from table order by orderfield
分别看看运行的时间也许就知道了,并且保证你永远不会忘记的.
insert into testaaa values('222','222')
insert into testaaa values('111','111')
insert into testaaa values('333','333')
insert into testaaa values('444','444')
insert into testaaa values('555','555')
insert into testaaa values('888','888')
insert into testaaa values('666','666')
insert into testaaa values('777','777')
insert into testaaa values('999','999')
insert into testaaa values('000','000')
insert into testaaa values('112','112')
insert into testaaa values('212','212')
insert into testaaa values('232','232')
insert into testaaa values('225','225')
insert into testaaa values('228','228')
select * from testaaa
select * from testaaa order by aaa
select top 10 * from testaaa order by aaa