The other simple solution is to do something like this. Select changed FROM archived_stats order by changed DESC limit 0,1
I haven't actually tried it, it may be just as slow. If you always know that you have dates in the changed for the past week or past day, this may be an even better solution for you. Select changed from archived_stats where changed > DATE_SUB(NOW(), INTERVAL 1 DAY) order by changed DESC limit 0,1 Hope this helps. Donny > -----Original Message----- > From: Dave Dyer [mailto:[EMAIL PROTECTED] > Sent: Saturday, September 04, 2004 2:58 AM > To: Dan Nelson > Cc: Donny Simonton; [EMAIL PROTECTED] > Subject: Re: please explain why this query isn't optimized > > > > > >> Getting the same answer, from a simpler query, in infinitely > >> less time, just seems wrong to me. > > > >Makes perfect sense. Simpler queries *are* easier to optimize, you > >know :) > > > Makes perfect sense. Thanks, I think the relevant points > have been covered. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
