인덱스스킵스캔 예제

- 테이블 생성
create table index_skip_scan
(
gubun varchar2(1),
work_date varchar2(8),
test_desc varchar2(100)
);

- 인덱스 생성
create index index_skip_scan_n01 on index_skip_scan
(gubun,work_date)
;

- 테스트데이터 입력
insert into index_skip_scan
select 'A',to_char(sysdate - rownum,'yyyymmdd'),'asdadasdadas' from dual connect by level <= 10000
union all
select 'B',to_char(sysdate - rownum,'yyyymmdd'),'asdadasdadas' from dual connect by level <= 10000
;

commit;

- SQL 수행
select * from index_skip_scan where work_date in ('20080225','20080226');

• TRACE 결과