Specifying an index on a field causes the DBMS to maintain a sort order on that field. The records are not physically sorted on the field, rather an index is created with the field so that sorting is greatly simplified.
For example, in a Client table, ClientID may be the primary key that...