Timing on using MAX()

[X Y]

Hi All,
I timed 2 sql statements:
SELECT MAX(id) FROM TABLE1
AND
SELECT id FROM TABLE1 ORDER BY ID

The field ID is indexed; however, how come MAX() takes
twice as long to retrieve. + it seems like it affects
other queries as well.

Thnx

__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com