Hi Guys,

I have a table which contains a Column as Entrry date and this table have values as Order by that date, When I create an index on a Column, This Disturbs the Order in Totally different way, Does any one know WHY is This.. Even it is not desired or required. Actually I shold say it Changes the Order of the Entries in the Table.

Here is What I have..
SQL> select media_id, seq_no, entered_on_date from medloc
2 where media_id = 100;

MEDIA_ID SEQ_NO ENTERED_O
---------- ---------- ---------
100 26-SEP-95
100 27-SEP-95
100 27-SEP-95
100 25-FEB-98
100 21-APR-99

5 rows selected.

SQL> create index idx on medloc(media_id);

Index created.

SQL> select media_id, seq_no, entered_on_date from medloc
2 where media_id = 100;

MEDIA_ID SEQ_NO ENTERED_O
---------- ---------- ---------
100 25-FEB-98
100 21-APR-99
100 26-SEP-95
100 27-SEP-95
100 27-SEP-95

5 rows selected.

SQL> drop index idx;

Index dropped.

SQL> select media_id, seq_no, entered_on_date from medloc
2 where media_id = 100;

MEDIA_ID SEQ_NO ENTERED_O
---------- ---------- ---------
100 26-SEP-95
100 27-SEP-95
100 27-SEP-95
100 25-FEB-98
100 21-APR-99

5 rows selected.

If You see the Entered_on_date Columns has to be in the date Order, This way I am getting the Seq_No, But I need the Index to speed up the Update...

Can any one please Comment, Why does it change the Order of the data in the table.

Thanks in Advance.