a surrogate key is 4 byte int bu which we can track 2 billion records,
if records more than 2 billion what is the solution
can i reset a surrogate ky? 4 byte tracks 2 billion if more?
Moderators: chulett, rschirm, roy
If you choose a 64-bit integer in the Surrogate Key Stage you can track surrogate keys from 0 through 9223372036854775807 ((2^^64/2)-1). If you are using a 4-byte key ((2^^32/2)-1) you have 2147483647 positive numbers (double that if you also use negative ones).
I don't know what your actual question is. If you utilize a 4-byte integer in the database for the surrogate key you are limited as above and there is nothing you can do unless you either store less records or use another datatype or add an additional column in the table to make up a unique key.
I don't know what your actual question is. If you utilize a 4-byte integer in the database for the surrogate key you are limited as above and there is nothing you can do unless you either store less records or use another datatype or add an additional column in the table to make up a unique key.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Sainath - I can't find any way to make the Surrogate Key stage in Px use anything but integers. How do you specify NUMBER (and how can one really use a floating-point representation for a unique key without having to worry about duplicates)?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 108
- Joined: Mon Oct 21, 2002 8:30 am
Yes, it needs to be moved forthwith - I didn't realize which forum we were in.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>