[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