I have a query that is identical except for the method of sorting. Here are the differences.
ORDER BY score
ORDER BY entry_date DESC
I created two indexes and verified that they are being used and no filesort occurs, but the entry_date query is ~20X faster than score.
score is a float and entry_date is datetime. I didn’t specify a size for the float, but in looking at the data they all have either a 0 or 1 and 6 decimal places.
Is there a different datatype that I should be using?