repeating column in index?

From: Kenny Yu <kyu_at_biodiscovery.com>
Date: Fri, 2 May 2003 10:44:57 -0700
Message-ID: <vb5bdt9og387ca@corp.supernews.com>

Oracle 8.1.7 mysteriously changes my index definition and repeats column.

I ran:
CREATE INDEX GD_AGGREG_MST_ID ON
GD_AGGREGATION(MASTER_ID, detail_id);

to index two columns.

Afterwards I got:

SQL> select column_name, column_position from user_ind_columns SQL> 2 where index_name ='GD_AGGREG_MST_ID';

COLUMN_NAME COLUMN_POSITION

---

MASTER_ID 1 MASTER_ID 1

DETAIL_ID                2


-------------------------------------------------

Why is the first column repeated? Received on Fri May 02 2003 - 12:44:57 CDT