List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:September 17 2002 7:55pm
Subject:Re: Forcing a sort order in a join
View as plain text  
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
>


Thread
Forcing a sort order in a joinPhilip Smolen14 Sep
  • Re: Forcing a sort order in a joinGerald Clark17 Sep
  • Re: Forcing a sort order in a joinPhilip Smolen18 Sep
  • Re: Forcing a sort order in a joinGerald Clark18 Sep