>By the way, I have heard that SQL's work slower when tables are ordered. Is that true?
>
Yes, where reference is made to an existing open table by alias, and the work area has an index in effect, since if there's an index in effect on the alias and the table needs to be traversed record by record, it'll have to be traversed in the index order in effect in the work area referenced. This means that each time you move from one record to the next, the index is consulted to determine which record gets visited next. If no index is active (SET ORDER TO 0) then the overhead of record traversal by lookup in the index is removed.