On Fri, Oct 03, 2003 at 06:06:10PM -0400, John Kornet wrote: > 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 is redudndant, yes. > In other words, does the left-prefix rule apply to unique indexes that > specify uniqueness over multiple columns? Yes. A unique index is a "normal" index with an additional constraint. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 19 days, processed 719,668,581 queries (418/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
