[thelist] mysql primary key multiple columns
Scott Dexter
sgd at ti3.com
Wed Aug 30 10:02:47 CDT 2000
> so i guess, scott, your advice is fine, assuming that the reason for
> wanting a pk was this, um, side-benefit, that it's (by
> definition) unique
>
> but if what you want is what a pk is for, then no way a
> unique index is
> faster -- heck, look at all the triggers and stored procs
> you'd have to
> write
yah, and the reason I said "may be" was because I wasn't sure of the
performance implications; I's just making a suggestion. Thanks for the
clarification--
> sorry to be the pedant around here, but somebody's gotta do it
like I've never been the pedant...
sgd
More information about the thelist
mailing list