Timing on using MAX()

[X Y]

YES that is correct.
I used a cursor the open the query.
I am using Director.



--- Ruslan Zasukhin <sunshine at public.kherson.ua>
wrote:
> 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
>
-------------------------------------------------------------
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina


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