Community

Using index for ORDER BY vs restricting number of rows

(Peter Zaitsev) One interesting problem with MySQL Optimizer I frequently run into is making poor decision when it comes to choosing between using index for ORDER BY or using index for restriction.

Read More - Register for Free Membership