Index: openacs-4/packages/acs-mail/sql/oracle/acs-mail-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail/sql/oracle/acs-mail-create.sql,v
diff -u -r1.2 -r1.2.4.1
--- openacs-4/packages/acs-mail/sql/oracle/acs-mail-create.sql	13 Aug 2001 16:18:45 -0000	1.2
+++ openacs-4/packages/acs-mail/sql/oracle/acs-mail-create.sql	3 Feb 2003 16:08:00 -0000	1.2.4.1
@@ -196,6 +196,11 @@
             references acs_objects on delete cascade
 );
 
+-- RI Indexes 
+create index acs_mail_bodies_item_id_idx ON acs_mail_bodies(content_item_id);
+create index acs_mail_bodies_body_from_idx ON acs_mail_bodies(body_from);
+create index acs_mail_bodies_body_reply_idx ON acs_mail_bodies(body_reply_to);
+
 create table acs_mail_body_headers (
     body_id integer
         constraint acs_mail_body_heads_body_id_fk
@@ -231,8 +236,10 @@
     constraint acs_mail_multipart_parts_pk
         primary key (multipart_id, sequence_number)
 );
+--RI Index
+create index acs_mail_mpp_cr_item_id_idx ON acs_mail_multipart_parts(content_item_id);
 
-  -- Mail Links
+-- Mail Links
 
 create table acs_mail_links (
     mail_link_id integer
