本文介绍三种高效获取数据的方法：使用系统引导排序、随机排序和样本排序。这些方法通过不同的策略优化查询性能，适用于不同场景的需求。
1) select * from (select * from tablename order by sys_guid()) where rownum < N;
2) select * from (select * from tablename order by dbms_random.value) where rownum< N;
3) select * from (select * from table_name sample(10) order by trunc(dbms_random.value(0, 1000))) where rownum < N;
2) select * from (select * from tablename order by dbms_random.value) where rownum< N;
3) select * from (select * from table_name sample(10) order by trunc(dbms_random.value(0, 1000))) where rownum < N;
扫一扫
979
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
