Originally posted by adewri
Pardon my ignorance, but i would like to know why would any one have 10 indexes on one single column. Doesn't make any sense to me, neither from the design point of view nor from coding point of view.
adewri, never mind making sense, it's impossible to do multiple indexes on a single column.

SQL> create table test (a number, b number);

Table created.

SQL> create index test_1 on test(a);

Index created.

SQL> create index test_2 on test(a);
create index test_2 on test(a)
*
ERROR at line 1:
ORA-01408: such column list already indexed