- Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688
-->-----Original Message----- -->From: John Kornet [mailto:[EMAIL PROTECTED] -->Sent: Friday, October 03, 2003 3:06 PM -->To: [EMAIL PROTECTED] -->Subject: Multiple-Column Unique Index Redundancy --> -->I've been over a few books, the site, and the archives... Can someone -->please confirm that if I create a unique index over 2 columns, it will -->be redundant to create a regular index for the first? It would be redundant. --> -->In other words, does the left-prefix rule apply to unique indexes that -->specify uniqueness over multiple columns? If col1 and col2 is a unique index col1 is just a reg index. http://www.mysql.com/doc/en/MySQL_indexes.html --> -->Thanks in advance for taking a few minutes for me! -->John Kornet --> --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]