/Pankaj Tanwar

What Is The Sorting Algorithm Behind ORDER BY Query In MySQL? tl;dr: mySQL's sorting algorithm depends on available indexes, expected size of result & mySQL version, and has two methods to produce sorted / ordered streams of data - a smart use of indexes and the Fiilesort algorithm. Pankaj discusses both.

featured in #239