Re: Forcing a sort order in a join

[Gerald Clark]

Using DESC on an index only works with V 4.

Philip Smolen wrote:

>I'm trying to make a query faster.  It seems simple, but I can't make it
>work.
>
>This is a common case for me:
>SELECT *
>FROM very_large_table
>WHERE (simple_condition)
>ORDER BY an_indexed_field DESC
>LIMIT 5;
>For simple queries this works as expected.  MySQL starts at the end of the
>