-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|