Re: Most efficient way to get max row id?

> On Sunday 19 October 2008 02:04:29 pm Amir Michail wrote:
>> 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?
>
> In the particular table, how many rows are you referring to? A few thousand? A
> few million?  A hundred million?
>
> Do you have an index on the identity column?  What's your datatype?