General information
Title:
Surrogate number primary keys
If I use an incrementing number as a surrogate primary key, why should I make it a character field? Tastrade does that, and I've heard that it's the thing to do. But a key like this is not useful for ordering the records, and therefore would not be part of compound index expressions. Wouldn't it be better to use a double field?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only