Question

oracle 如何最快地从一张表里随机提取10条记录？

Answer 1

通过采样表扫描最快//。。。

select * from (select * from largetable sample(20)) where rownum <=10;

Answer 2

这个最快了。
select * from table where rownum <= 10;

追问

要随机