Hello all, I have a link table that relates 'Profiles' with 'Categories':
CREATE TABLE lnk_profile_category ( profile_fk int(11) NOT NULL default '0', category_fk int(11) NOT NULL default '0', PRIMARY KEY (category_fk,profile_fk) ) TYPE=MyISAM; If I expect that my most frequent queries are going to be those that select profiles in a given category -- i.e.: (select * from profile <Yadda-Yadda-JOIN> where category.label = 'widgets' ) -- is it better to define my PK as: 1. PRIMARY KEY (category_fk,profile_fk) --Rather than-- 2. PRIMARY KEY (profile_fk,category_fk) ?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
