Jan/09
8
MySQL - ORDER BY RAND() optimization
0 Comments | Posted by Žilvinas Šaltys in Lazyweb, MySQL
Interesting read about order by rand optimization by Jan Kneschke. Haven’t used this myself but seems might be rather useful. The performance difference is huge. I wonder if MySQL could optimize ORDER BY RAND() itself when there are no data holes.