SELECT * FROM (SELECT r_t.*, ROWNUM r_rownum FROM ( select /*+rule*/ subscribersn from subscriberrentinfo where version >= :1 and version <= :2 ) r_t WHERE ROWNUM < :3 ) WHERE r_rownum >= :4
性能测试时发现此行语句执行时耗时最多,CPU使用率98%,请问如何进行优化
...全文
2686打赏收藏
分页语句如何优化效率
SELECT * FROM (SELECT r_t.*, ROWNUM r_rownum FROM ( select /*+rule*/ subscribersn from subscriberrentinfo where version >= :1 and version <= :2 ) r_t WHERE ROWNUM = :4 性能测试时发现此行语句执行时耗时最多,CPU使用率98%,请问如何进行优化