Optimize MYSQL Query with Order by

Question

I have seen mysql queries with order by runs slow.

Is there any specific way to optimize queries which use order by ?

Queries without order by run very fast but with order by its always runs slow.

if any one suggest any thing on this as general solutions.

Thank You

Answer 1

You could find an exhaustive answer on Mysql Site on ORDER BY Optimization.