ORDER BY ... DESC LIMIT 1 optimization ?

[Michael Widenius]

Hi!

>>>>> "Fournier" == Fournier Jocelyn <Fournier> writes:

Fournier> Hi,
Fournier> Won't it be possible the MySQL parser optimize the SELECT y FROM x ORDER BY
Fournier> z DESC LIMIT 1 as :

Fournier> SELECT MAX(z) FROM x;
Fournier> followed by :
Fournier> SELECT y FROM x WHERE z=a;

Fournier> (where 'a' is the result of the first SELECT MAX(z) query)

Yes this is possible;  MySQL 4.0 already does this.

<cut>

Regards,
Monty