描述信息 |
内容结果 |
|||
count(*)比count(字段) |
如果在开始时没有执行过count(最小字符的字段)来统计个数,count(*)不比count(字段)慢 Ge: declare @d datetime set @d=getdate() SELECT count(*) FROM [TestPaging02].[dbo].[TGongwen] select [用时(毫秒)]=datediff(ms,@d,getdate()) -----用时:21193--- |
次数 |
Count(*) |
Count(gid) |
1 |
743 |
720 |
||
2 |
686 |
743 |
||
3 |
753 |
686 |
||
字段提取要按照“需多少、提多少”的原则[H1] |
declare @d datetime set @d=getdate() select top 10000 gid from tgongwen order by gid desc select [用时(毫秒)]=datediff(ms,@d,getdate()) |
3000 |
||
select top 10000 gid,fariqi,titlefrom tgongwen order by gid desc |
7436 |
|||
select top 10000 gid,fariqi,title,readerfrom tgongwen order by gid desc |
17180 |
|||
order by按聚集索引列排序效率最高 |
select top 10000 gid,fariqi,reader,title from tgongwen(没有order by操作) |
533 |
||
select top 10000 gid,fariqi,reader,title from tgongwen order by gidasc |
363 |
|||
select t |