Not sure how anyone can guarantee a "10 year solution" for you, not knowing your data volumes. Regardless, make sure your ids are "big enough" to hold whatever they need to hold.devesh_ssingh wrote:please share any long term solution which would not exhuast in span of 10 years.
However, is there really anything wrong with a negative number for a surrogate? (note I said "negative" not "-ve", an abbreviation that irks the crap out of me) Unless you've assigned special significance to them, then I don't see an issue per se. However, you could "fix" this and leave the existing values in place or "correct" them if they bother you, that's just math and some constraint games.