Oracle 페이징,리스팅,인덱스

게시판 페이징..  : -> rownum

$cfg->postnum=10;
$page = 1;

SELECT
 cn_num, cn_kind, cn_title,cn_contents, cn_cnt,to_char(cn_inputdate,'yyyy/mm/dd'), cn_use
FROM
     (SELECT
         /*+index_desc(cn_announce_cn_num_pk)*/
         rownum as rnum, cn_num, cn_kind, cn_title,cn_contents, cn_cnt,cn_inputdate, cn_use
     FROM
          (SELECT cn_num, cn_kind, cn_title,cn_contents, cn_cnt,cn_inputdate, cn_use
          FROM cs_announce
          ORDER BY cn_num desc
     )
     WHERE cn_use='Y'";
 )
WHERE rnum >= (($page-1)*$cfg->postnum+1)  AND  (rownum <= $cfg->postnum)

참고해볼 심화학습들....
http://cafe.naver.com/crystal510.cafe?iframe_url=/ArticleRead.nhn%3Farticleid=16586

http://kin.naver.com/db/detail.php?d1id=1&dir_id=10111&eid=5+2oDgu0evvzn3eRU3mby3stDqdiTlgl&qb=bGltaXQgcm93bnVt

http://blog.naver.com/hjc426?Redirect=Log&logNo=130021050759

=================================================

알고리즘

http://www.javaservice.net/~java/bbs/read.cgi?m=devtip&b=servlet&c=r_p&n=987410410&p=32&s=t#987410410

 ======================================================

쿼리속도향상 인덱스 최적화

http://www.javaservice.net/%7Ejava/bbs/read.cgi?b=jdbc&c=r_p&m=etc&n=989891542&s=t