db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kai Ponte <...@perfectreign.com>
Subject Re: Most efficient way to get max row id?
Date Mon, 20 Oct 2008 03:25:48 GMT
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@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?

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?

www.filesite.org || www.perfectreign.com

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

View raw message