As i have to do an order by, on a column for a table having millions of records, I found an approcah which can do faster sort in the following way. It is like doing an Inner Join with a result set which is ordered by the interested order by column, where in such column has to be indexed, so that it…

Order by using an Inner Join not working in Linux environment of Mysql

Nagini April 23, 2015, 1:00am 2

Waiting for the reply… pls help

Topic		Replies	Views
ORDER BY ..LIMIT using indexes still slow Other MySQL® Questions	4	576	April 14, 2008
MySql Order by on a huge joined datasets is taking too long time. Other MySQL® Questions	24	1546	May 5, 2015
Mysql not using index for ORDER BY ? Other MySQL® Questions	2	528	May 13, 2007
Problems getting ORDER BY to use index Other MySQL® Questions	3	649	November 12, 2006
optimization for inner join.. order by.. limit with large order by data Other MySQL® Questions	4	592	January 13, 2010