Index: openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-create.sql,v
diff -u -N -r1.19 -r1.20
--- openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-create.sql	29 Mar 2018 17:28:50 -0000	1.19
+++ openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-create.sql	5 Dec 2018 12:45:08 -0000	1.20
@@ -400,6 +400,8 @@
 	on acs_mail_lite_ie_section_ref_map (section_id);
 
 --
+-- TODO: this table does not exists for Oracle.... Not needed there?
+--
 create table acs_mail_lite_send_msg_id_map (
        -- a randomized number unique to this table
        -- unique not null
@@ -425,3 +427,9 @@
 create index acs_mail_lite_send_msg_id_map_msg_id_idx
        on acs_mail_lite_send_msg_id_map (msg_id);
 
+--
+-- Speed up referential integrity
+--
+CREATE INDEX acs_mail_lite_send_msg_id_map_package_id_idx ON acs_mail_lite_send_msg_id_map(package_id);
+CREATE INDEX acs_mail_lite_send_msg_id_map_party_id_idx   ON acs_mail_lite_send_msg_id_map(party_id);
+CREATE INDEX acs_mail_lite_send_msg_id_map_object_id_idx  ON acs_mail_lite_send_msg_id_map(object_id);