>> First: select * from table1 order by field1 asc limit 1
>> Last: select * from table1 order by field1 desc limit 1
> That only returns one number.. what we are really looking for is something
And worse: as far as I can tell 3.22.x even if field1 is indexed, ONE
of those queries is going to be very slow. The query planner doesn't
seem to be smart enough to read the index in reverse for ORDER BY DESC
clauses.
--
thanks,
Will
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
