两种做法,大家觉得哪个效率高:
1,select top 100 a,b,c,d,f,g,h,i,j,k,l,m from table order by a
2,select top 100 a from table order by a
{
select a,b,c,d,e ,f,g,h... from table where a=...
}
...全文
388打赏收藏
求助一个数据库性能问题
两种做法,大家觉得哪个效率高: 1,select top 100 a,b,c,d,f,g,h,i,j,k,l,m from table order by a 2,select top 100 a from table order by a { select a,b,c,d,e ,f,g,h... from table where a=... }