"Angva" <angvaw@xxxxxxxxx> writes: > As others have said, sequences can have gaps. In fact, the thought of > a gap-free sequence is scary to me. Unless you do very few inserts, > "gap-free sequence" is pretty much synonymous with "not scalable". If > your goal is to generate a unique number for each row (which is > usually the case), then gaps should be fine. > > Though I must admit I have occasionally wished for sequences with a > GAPFREE option...For small, static look-up tables that I update once > in a blue moon. It's just easier on the eyes to have 1,2,3,4,5 than 1, > 25, 2405, 95720, 59028598253. There's a recipe for gapless sequences on Varlena (if you can access it from your end...) that was the result of discussions here. There's a performance hit, of course, but it works. -- Jorge Godoy <jgodoy@xxxxxxxxx>
