SOFTMOA TECHNOLOGY
[ oracle ] paging query 페이징 처리 속도 향상
소프트모아가 정리한 기술 기록입니다.
Contents
작성일 2016. 06. 01.
기존
SELECT * FROM (
SELECT A.*,
ROWNUM AS RNUM,
COUNT(*) OVER() AS TOTCNT FROM (
쿼리, 조건,정렬
) A
) WHERE RNUM > '부터' AND RNUM <= '까지'
SELECT
SELECT * FROM (
SELECT A.*,
ROWNUM AS RNUM,
COUNT(*) OVER() AS TOTCNT FROM (
쿼리, 조건,정렬
) A
) WHERE RNUM > '부터' AND RNUM <= '까지'
SELECT
*
FROM (
SELECT
SELECT
ROWNUM AS RNUM
, A.*
FROM (
쿼리, 조건,정렬
) A
쿼리, 조건,정렬
) A
WHERE
ROWNUM <= '까지'
)
)
WHERE
RNUM > '부터'
Share this
Database
Showing 1 to 10 of 88 entries
