Re: ORDER BY queries optimizing with INDEX

2001-08-23 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 (ASTURIA