Re: ORDER BY queries optimizing with INDEX

2001-08-24 Thread Jeremy Zawodny
On Thu, Aug 23, 2001 at 07:21:10PM +0200, Gregorio Ramón Alberdi Díaz wrote: A query with a ORDER BY clause over a numeric field, will be fast if this field have a index or this doesn't influence the anwer time of the query. MySQL is going to prefer an index on the column(s) used in the

ORDER BY queries optimizing with INDEX

2001-08-23 Thread Gregorio Ramón Alberdi Díaz
A query with a ORDER BY clause over a numeric field, will be fast if this field have a index or this doesn't influence the anwer time of the query. Thanks. -- Gregorio R. Alberdi Díaz - [EMAIL PROTECTED] AVILÉS