Matthew O'Connor wrote: > Quick Summary - I suggest we add the following two indexes: > CREATE INDEX dbmail_headervalue_physmsg_id on dbmail_headervalue > (physmessage_id );
ok. Though I assumed this was implied by the unique key already present. > CREATE INDEX dbmail_headername_lower_headername on > dbmail_headername(lower(headername)); I'll changing the unique key on headername to a unique key on lower(headername) -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl