Re: Query using "ref" instead of "range" access

[Rick James]

Is the stored procedure faster or slower?

See if this works any faster:

SELECT SQL_NO_CACHE scores.lid, scores.score,
   ( SELECT COUNT(s2.score)+1
          FROM scores AS s2
          WHERE s2.lid=scores.lid
            AND s2.score>scores.score )
    FROM scores
    WHERE scores.pid=186359
   GROUP BY scores.lid;