In other DBMSs indexes speed the process of sorting on a field in an
ORDER BY clause if the same conditions for WHERE and JOIN clauses are
met. I didn't see this mentioned in the docs on indexes though. Does
an index also speed sorting as it does lookup in the other clauses?
Jeff Willden
