Oracle位图索引

desc emp

select distinct job from emp;

select * from emp;

select empno, ename, sal from emp where job='CLERK';

create bitmap index emp_job_bitmap_idx on emp(job);

col index_name for a24
col index_type for a15
col table_name for a10
select index_name, index_type, table_name, status from user_index where index_name like 'EMP%';

select dbms_metadata.get_ddl('INDEX','EMP_JOB_BITMAP_IDX') from dual;

alter system flush shared_pool;

alter system flush buffer_cache;