Fast creation of surrogate keys in Greenplum
January 15th, 2013
No comments
Usually we use sequence to generate unique identifier for surrogate keys. A sequence is simply a database object that return a number every time you call it. Sadly today I face a limit in the sequence implementation of Greenplum. In the process of finding a solution, I found a way to generate surrogate keys faster than sequence (another way is in this blog).