At 18:06 -0400 10/3/03, 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?
In other words, does the left-prefix rule apply to unique
- 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 Uniq
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
