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?
In other words, does the left-prefix rule apply to unique indexes that specify uniqueness over multiple columns?
It will be redundant to create an index on the first column, yes.
However, the values in the first column of the index will not necessarily be unique.
Thanks in advance for taking a few minutes for me! John Kornet
You may want to read about leftmost prefixes in the MySQL Reference Manual.
http://www.mysql.com/doc/en/MySQL_indexes.html
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
