Index: openacs-4/packages/notifications/sql/oracle/notifications-replies-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/oracle/notifications-replies-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/notifications/sql/oracle/notifications-replies-create.sql	9 Aug 2002 20:51:49 -0000	1.2
+++ openacs-4/packages/notifications/sql/oracle/notifications-replies-create.sql	17 May 2003 10:52:25 -0000	1.3
@@ -27,6 +27,10 @@
        reply_date                 date
 );
 
+-- RI indexes
+create index notif_repl_from_user_idx ON notification_replies(from_user);
+create index notif_repl_type_id_idx ON notification_replies(type_id);
+create index notif_repl_object_id_idx ON notification_replies(object_id);
 
 declare
 begin
