Did you try a straight join so MySQL won't swap the order of the tables?
Philip Smolen wrote:
>Right. The simple example listed at the bottom of this message works great
>under version 4. Version 3 gave the right answer, but it was very slow.
>That made me upgrade to version 4.
>
>However, eve
PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, September 17, 2002 12:55 PM
Subject: Re: Forcing a sort order in a join
> 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
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 quer
