<No Subject Supplied>

There is a thread running regarding serial numbers. =20 I believe there is a misconception that serial numbers assume = uniqueness. Where this is logical, I do not believe it is correct. = When using serial values you must set a unique index or constraint. For = instance, I could manually add a duplicate number. Informix assigns a serial value based upon the highest last value. If = you have the values 1, 4, 100 the next value Informix assigns will be = 101. By using integer values in a load, I could assign any number. = Again, Informix would pick up it's assignment based on the highest = value. I have a programmer that uses serial values heavily because an Informix = techy told him they were faster. Personally, I think they are much more = trouble than any performance you gain. I mean, let's get a little bit = twiddly......