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

@Graphain done, I am always reluctant to write so short answer with a link. — Julien Hoarau
– Julien Hoarau, Commented Jun 18, 2010 at 9:29

Julien Hoarau · Accepted Answer · 2010-06-18 09:27:47Z

2

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

answered Jun 18, 2010 at 9:27

Julien Hoarau

50.2k20 gold badges134 silver badges117 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1