Multiple indexes on the same column
Multiple indexes on the same column Until the release Oracle 11g was not possible to create more indexes on the same column of a table. Starting from release Oracle 12c, you can create multiple indexes on the same column as long as the index type is different. However, only one type of index is usable / visible at a given time. To test the indexes invisible, you must set the init.ora parameter: optimizer_use_use_invisible_indexes = true; Not using INVISIBLE clause will result in the error: ORA-01408: such column list already indexed An example: create unique index test_idx1 on test_tab (id1); index...