To do this you are going to copy to a new table. After copying to a new table you can delete the original and rename the new table to the original name.

There are various ways to copy to a new table with a specific sorted order..

1. Select * from (originaltablename) into table (newtablename) order by (sort expression)

2. Open the original table. Create or set index to appropriate order. Scan the table and copy records one-by-one to the new table.

3. use the SORT command.

Once this is done, the records in the new table will only be sorted properly until a new record is added.

you are much better off and more flexible using a structural index and setting the index tag when opening the table. This will ensure the index order is updated when records are added/deleted/modified.

>There is nothing more to that, the physical sort would not change.
>
>Yes, how to sort physical sort according to given index?