2020-10-21 oracle查询性能
测试数据 200w
select * from tbl ; 59s
select * from tbl where rownum < 10w ; 3.2s
select * from tbl where rownum < 100w ; 30.4s
select b.* from (select rownum as row_num, a, b, c from tbl a where rownum < 190w) b where b.row_num > 180w ; 4.4s
同上 &l
原创
2020-10-21 23:26:59 ·
249 阅读 ·
0 评论