Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-08 : 08:46:22
|
Steve Nelson writes "We've been having a debate on the Fusebox.org mailing list (Fusebox is an open web architure for scripting languages) about which is best as a primary key....
1) using an indentity column
2) using a UUID in a set-length char field
3) using select max(ID) on a straight int field
We've all got our different theories and problems on this, what we're looking for are some actual metrics comparing the different techniques.
Do you have any?
Steve Nelson" |
|
|
|
|
|
UUIDs as PKs vs identity keys as PKs