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

- 인덱스 생성
create index index_full_scan_n01 on index_full_scan
(gubun,work_date)
; 

- 데이터 입력
insert into index_full_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 count(*) from index_full_scan 
where gubun = 'A'
;

• TRACE결과