Re: Most efficient way to get max row id?

On Sunday 19 October 2008 09:15:55 pm Amir Michail wrote:
> > Do you have an index on the identity column?  What's your datatype?
>
> ~60,000 rows
>
> So if I put an index on the identity column, max will be fast?

It will certainly be faster than without.

--
kai
www.filesite.org || www.perfectreign.com

 
Clean out a corner of your mind and creativity will instantly fill it. - Dee
Hock