Showing entries 1 to 1
Displaying posts with tag: Filesort in mysql (reset)
Aug
26
2011
How MySQL does sorting with Order By
Posted by Nilnandan Joshi on Fri 26 Aug 2011 12:31 UTC
Tags:

There are two filesort algorithms in MySQL for sorting and retriving select queries results. 1. Original Filesort Algorithm : This method uses only the ORDER BY columns. (prior to MySQL 4.1) 2. Modified Filesort Alforithm : This method uses ORDER BY columns and the columns which are used in query. [...]

Showing entries 1 to 1