如果你的需求不需要非常实时的统计,那你可以用固定表,做个job每天晚上统计插入,如果你的需求必须完全实时准确的统计,你只有在设计表和建索引上下工夫了!
解决方案 »
- SQL group by语句的使用
- sql server2000数据库语句
- 对表进行insert,update时如何进行防出错处理,比如表锁死之类
- 求一SQL语句
- 一个"时间"相关 "数据类型" "not in"的问题
- 为什么这样写不行??
- 在动态sql里面如何返回动态变量的值?
- 我的msde装好之后,为什么用sa登录不了阿???
- 在程序中如何通过视图名称获取视图的SQL定义?(对不起,我的可用分不多了)
- sqlserver2000 中发mail的问题,请大家帮忙,在线等待!
- 如何备份SQL2000的数据库,请问可不可以导成别的文件的形式,保存在另一个地方呢?
- 大家请帮帮忙,我这存储过程语法错在那里
PIII900 128M
win2000+sql server2000企业版
table name :t_data
CLUSTERED PRIMARY KEY :id
Rows:441000语句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 asccreate 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 asccreate 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 asccreate 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 asccreate 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 asccreate 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 asccreate 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 asccreate 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时间:过了25m没有出来,还没有中断