Re: ORDER BY ... DESC LIMIT 1 optimization ?

[Timothy Smith]

On 2001 Sep 06, Fournier Jocelyn [Presence-PC] <joc@stripped> wrote:
> It doesn't change anything, the query is still slow.

OK, I believe that the optimization is not being done because
MySQL doesn't realize that the ORDER BY is on the second part
of the same key that is used for the WHERE clause.

This might not be easy to fix in a general way, but we will
look into it.

Tim

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Tim Smith <tim@stripped>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-time Developer
/_/  /_/\_, /___/\___\_\___/   Boone, NC  USA
       <___/   www.mysql.com