Question: what is the difference between creating an index & an order by clause?
Answer: ORDER BY is applied only when reading. A single column may be used in indexes in which case there could be several different kinds of ordering in sql query requests. ... Index effects the performance of a query when doing all the Create, Read, Update and Delete operations.