drop table EMP1 purge ;
create table EMP1 as select employee_id empno, first_name ename from employees ;

create index nui_emp1_empno_ename on emp1(empno, ename) ;

select index_name, last_analyzed, num_rows, sample_size from user_indexes where table_name = 'EMP1' ;

INDEX_NAME                     LAST_ANALY   NUM_ROWS SAMPLE_SIZE
------------------------------ ---------- ---------- -----------
NUI_EMP1_EMPNO_ENAME           11/02/2007        107         107