On Mon, 22 Nov 2004 12:33:20 +1300, Mark Mackay - Orcon <[EMAIL PROTECTED]> wrote: > Found a post regarding this in the mailing list archive, but no response to > it: > > > Brian Blood brian at macserve.net > > Thu Nov 27 16:56:42 CET 2003 > > why is there both a Primary and Unique index on the primary key field on > > these tables? > > aliases > > mailboxes > > messageblks > > messages
I don't think there's any benefit to having both the Primary and Unique indexes. I don't know why they ever got in there. If we take them out of the install scripts, we should also have to have some additional database migration scripts (for 1.2 old -> 1.2 new, and for 1.2 new -> 2.0). That would complicate matters for people updating to 2.0, because they would have to choose between two scripts. Please note that 2.0 and higher don't have these extra indexes. Ilja
