Index build on 1 field not unique - what is sortorder

[haezeban]

Hi,

Does anyone know how progress build the index.
Example Table1 with 4 fields : Id, Creation-time, Number, Description

1 10/02/2010 1000 Londen
2 10/02/2010 1000 New-York
3 10/03/2010 1000 Londen2
4 10/03/2010 1000 Brandon

I have a primaryindex on Id
and an index on Number 'Idx-Number'.

When I display the records with use of Udx-Number
I see always :
3 10/03/2010 1000 Londen2
4 10/03/2010 1000 Brandon
1 10/02/2010 1000 Londen

If the index is build on number what is de sequence progress uses? or the second field he uses?
I thougt if the index is not unique the sort order is in order if the primary key? But this is not.

I dumped and reloaded the table so the row-id's of the records changed. But still not in order of the prim key.
I also dumped en recreated the index ==> still not in order of the prim key.

So how this index is build and sorted if he is not unique.

(remark : it is not possible for us to change the indexes - so we need to load the data already in the correct way if possible)

Thanks,
Jac