On Sun, Oct 19, 2008 at 11:25 PM, Kai Ponte <[EMAIL PROTECTED]> wrote: > On Sunday 19 October 2008 02:04:29 pm Amir Michail wrote: >> On Sun, Oct 19, 2008 at 5:00 PM, Peter Ondruška >> >> <[EMAIL PROTECTED]> 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?
~60,000 rows So if I put an index on the identity column, max will be fast? Amir > > -- > kai > www.filesite.org || www.perfectreign.com > > > Clean out a corner of your mind and creativity will instantly fill it. - Dee > Hock > -- http://chatbotgame.com http://numbrosia.com http://twitter.com/amichail