db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Amir Michail" <amich...@gmail.com>
Subject Re: Most efficient way to get max row id?
Date Sun, 19 Oct 2008 21:04:29 GMT
On Sun, Oct 19, 2008 at 5:00 PM, Peter Ondruška
<peter.ondruska@gmail.com> 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@gmail.com> 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

Mime
View raw message