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 05:27:49 GMT
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

Mime
View raw message