Solutions to Improve Efficiencies of Random Select in MySQL

Solution 1 - just Order By Rand()SELECT * FROM user ORDER BY rand() LIMIT 10 This solution is not recommended, because...
ued