Index: openacs-4/packages/bulk-mail/sql/oracle/bulk-mail-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bulk-mail/sql/oracle/bulk-mail-create.sql,v diff -u -N -r1.3 -r1.4 --- openacs-4/packages/bulk-mail/sql/oracle/bulk-mail-create.sql 8 Aug 2006 21:26:15 -0000 1.3 +++ openacs-4/packages/bulk-mail/sql/oracle/bulk-mail-create.sql 11 Dec 2018 10:38:04 -0000 1.4 @@ -37,6 +37,7 @@ constraint bm_messages_status_nn not null ); +CREATE INDEX bm_messages_status_idx ON bulk_mail_messages(status); -- create a new object type begin