Re: Primary Key and autonumber

Maintain a last largest used number somewhere?? Why can't you just use SERIAL?? Francois Merle wrote: > > Let's assume I have a database that has 1 million records, all uniquely > identified with a Primary Key. > If my database does not provide an Autonumber for the Primary Key, how > can I efficiently give each new record a unique key without going > through the entire database to check if that value has already been > taken? > > Francois -- Paul Watson # WF Software # If it was easy Tel ++44 1436 674729 # Everybody could do it Fax ++44 1436 678693 # www.wfsoftware.com/informix #