平时在工作中较少涉及sql的优化,需要积累!
- 取一个表中前n条记录并排序
平时的写法是:select * from table where rownum >= 100 order by something
优化后的写法:select * from (select * from table order by something) where rownum >= 100
平时在工作中较少涉及sql的优化,需要积累!
平时的写法是:select * from table where rownum >= 100 order by something
优化后的写法:select * from (select * from table order by something) where rownum >= 100