Re: Most efficient way to get max row id?

by Amir Michail :: Rate this Message:

On Sun, Oct 19, 2008 at 5:00 PM, Peter Ondruška
<peter.ondruska@...> wrote:
> You want to use identity: Defining an identity column

Yes, but how do you get the max row id efficiently without adding another row?

Amir

>
> On Sun, Oct 19, 2008 at 10:52 PM, Amir Michail <amichail@...> wrote:
>>
>> Hi,
>>
>> I was wondering what is the most efficient way to get the max
>> automatically generated row id.
>>
>> select max(...) is slow.
>>
>> Amir
>>
>> --
>> http://chatbotgame.com
>> http://numbrosia.com
>> http://twitter.com/amichail
>
>

--
http://chatbotgame.com
http://numbrosia.com
http://twitter.com/amichail

« Return to Thread: Most efficient way to get max row id?