SQL & PL/SQL

Hi all,

I am having two tables with the following columns.

create table Table1 (col1 number, col2 number, col3 number);

create table Table2 (col1 number, col2 number, col5 number);

I have created index on Table1 like this.

create index idx1 on Table1(col1, col2) ;

I am trying to create index on Table2 like this and got Error : ORA-01408 Such column list already indexed

create index idx2 on Table2(col1, col2) ;

Here Index names and table names are Different, but columns used for creation of inedexes Same


My question here is, if i selected data from Table2, will idx1 index has been used here ? Oracle is giving error to create index on Table2 with same columns.

Thanks,
Pal