Optimize MYSQL Query with Order by

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

---

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