http://www.perlmonks.org?node_id=309301


in reply to Re: Problem with database under Win32
in thread Problem with database under Win32

Using SELECT TOP 1 From ..... ORDER BY ID DESC may be faster than trying a "Max".

I am not a SQL weenie though - you may want to check with your DBA as to why the subquery seems "slower".