Slow Startup with Foreign Members Table

ListManager scans foreign member tables for uniqueness every time it starts, which can take a very long time for large lists. The query run by ListManager is:

select emailaddr from foreignmembers
where emailaddr is NOT NULL" );
group by List_, emailaddr
having count(*) > 1

To avoid this lengthy table scan, you can create the following index:

create unique index IX_foreignmembers_List_EmailLC on foreignmembers(List_, UserNameLC_, Domain_);

You may change the name of the index and table name, but not the column names, ordering of the columns, or the "uniqueness" of the index. If this index exists, ListManager will not run the lengthy query on startup.