Timing on using MAX()

[Ruslan Zasukhin]

on 3/26/03 8:57 PM, X Y at xyzabc1010 at yahoo.com wrote:

> 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.

You mean that first query with MAX() is 2 times slower?

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------