Oracle 12C--Create multiple indexes on the same set of columns

In 12C, multiple indexes can be created on the same set of columns, but the types of multiple indexes are different. At the same moment, only one is visible.

 as Select  from EMP; SQL> CREATE INDEX emp_tab_ix_01 on Emp_tab (job,hiredate); -- before creating another index, change the index created in the previous step to the invisible state SQL> alter index emp_tab_ix_01 invisible; SQL> Create bitmap index emp_tab_bit_01 on Emp_tab (job,hiredate);

Oracle 12C--Create multiple indexes on the same set of columns