On Sun, Oct 19, 2008 at 1:52 PM, Amir Michail <[EMAIL PROTECTED]> wrote: > Hi, > > I was wondering what is the most efficient way to get the max > automatically generated row id. > > select max(...) is slow.
If this is an identity column, perhaps IDENTITY_VAL_LOCAL() suits your needs? http://db.apache.org/derby/docs/10.4/ref/rrefidentityvallocal.html andrew
