select count(1) from test group by type; time:6.02s
select count(url) from test group by type; time:6.04;
数据总量5000万。
url 为主键
url,type两个字段都有索引
怎么把性能性能提升到3s以内!!!!
...全文
3016打赏收藏
Oracle_count group by 优化
select count(1) from test group by type; time:6.02s select count(url) from test group by type; time:6.04; 数据总量5000万。 url 为主键 url,type两个字段都有索引 怎么把性能性能提升到3s以内!!!!