List:General Discussion« Previous MessageNext Message »
From:Wellington Fan Date:April 24 2006 5:29pm
Subject:Table design; 2-column index
View as plain text  
Hello List,

If I have a table:

CREATE TABLE t (
  id int(11) NOT NULL auto_increment,
  fk1 mediumint(9) NOT NULL default '0',
  fk2 smallint(6) NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY idxfk1 (fk1,fk2),
  UNIQUE KEY idxfk2 (fk2,fk1)
) TYPE=MyISAM;

I will about half the time have a query "WHERE fk1 IN (....)" and about the other half the
time have "WHERE fk2 IN (....)"

Does it make sense to define the UNIQUE KEYS the way I have?

Thanks!

--
Wellington
Thread
Table design; 2-column indexWellington Fan24 Apr
  • Re: Table design; 2-column indexDan Nelson24 Apr
RE: Table design; 2-column indexWellington Fan24 Apr
Re: Table design; 2-column indexDan Nelson24 Apr