Originally posted by grjohnson
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
Jurij has already pointed out this point.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"