/* Formatted on 2010/08/16 15:28 (Formatter Plus v4.8.8) */
SELECT   DECODE (TO_CHAR (access_date, 'DD'),
                 '', '합계',
                 TO_CHAR (access_date, 'DD') || '일'
                ) access_date,
         COUNT (DECODE (page_id, 1, 1)) pv_main,
         COUNT (DECODE (page_id, 2, 1)) pv_service_reg,
         COUNT (DECODE (page_id, 3, 1)) pv_eating,
         COUNT (DECODE (page_id, 4, 1)) pv_shopping,
         COUNT (DECODE (page_id, 5, 1)) pv_culture,
         COUNT (DECODE (page_id, 6, 1)) pv_entertainment,
         COUNT (DECODE (page_id, 7, 1)) pv_detail_coupon,
         COUNT (DISTINCT DECODE (page_id, 1, mdn)) uv_main,
         COUNT (DISTINCT DECODE (page_id, 2, mdn)) uv_service_reg,
         COUNT (DISTINCT DECODE (page_id, 3, mdn)) uv_eating,
         COUNT (DISTINCT DECODE (page_id, 4, mdn)) uv_shopping,
         COUNT (DISTINCT DECODE (page_id, 5, mdn)) uv_culture,
         COUNT (DISTINCT DECODE (page_id, 6, mdn)) uv_entertainment,
         COUNT (DISTINCT DECODE (page_id, 7, mdn)) uv_detail_coupon
    FROM page_view_tbl
   WHERE access_date >= TO_DATE ('201008', 'YYYYMM')
     AND access_date < LAST_DAY (TO_DATE ('201008', 'YYYYMM')) + 1
GROUP BY ROLLUP (TO_CHAR (access_date, 'DD'))

access_date 컬럼이 DATE 타입으로 되어있고, 해당 컬럼에 non-unique 인덱스가 생성되어 있는데도,

index 스캔을 하지 못하고 테이블 full scan 을 하고 있습니다.

잘못된 쿼리문이 존재하는지 답변 부탁합니다.;;