SELECT * FROM (
SELECT /*+ INDEX_DESC(Z OP_SAMPLE_PK) */ ROWNUM AS RNUM, Z.* FROM (
-- 원본쿼리
) Z WHERE ROWNUM <= 100
) WHERE RNUM >= 1
SELECT * FROM (
SELECT /*+ INDEX_DESC(Z OP_SAMPLE_PK) */ ROWNUM AS RNUM, Z.* FROM (
-- 원본쿼리
) Z WHERE ROWNUM <= 100
) WHERE RNUM >= 1