assumed that primary keys and linking keys should be numbers rather
than textual fields to improve performance. As an example, if i were
to create a new table i would put in a surrogate primary key that
autoincrements.
I've recently been challenged on this and cannot seem to find any
evidence that would support the view that this is best practice.
Anybody have opinions, or know of articles that provide any evidence
either way?"chris p reynolds" <chrispreynolds@.hotmail.com> wrote in message
news:78ba33c4.0404210124.60a744c9@.posting.google.c om...
> I've been designing SQL server databases for a while and have always
> assumed that primary keys and linking keys should be numbers rather
> than textual fields to improve performance. As an example, if i were
> to create a new table i would put in a surrogate primary key that
> autoincrements.
> I've recently been challenged on this and cannot seem to find any
> evidence that would support the view that this is best practice.
> Anybody have opinions, or know of articles that provide any evidence
> either way?
http://www.winnetmag.com/Articles/P...?ArticleID=5113
Simon
No comments:
Post a Comment