In the last episode (Apr 24), Fan, Wellington said:
> Thanks; I was really trying to ask about the potential performance
> gain, however. I don't care so much about the UNIQUEness, but the
> INDEXness.
>
> See, I am wondering if I create an 2-column index wiht fk1 as the
> first component, will th
query?
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 24, 2006 1:40 PM
> To: Fan, Wellington
> Cc: mysql@lists.mysql.com
> Subject: Re: Table design; 2-column index
>
>
> In the last episode (Apr 24), Fan, Wellin
In the last episode (Apr 24), Fan, Wellington said:
> 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 (