Index: openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql	20 Sep 2002 21:18:58 -0000	1.8
+++ openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql	16 Jan 2003 13:52:21 -0000	1.9
@@ -120,6 +120,8 @@
                                     check (format in ('text', 'html'))
 );
 
+create index notification_requests_t_o_idx on notification_requests(type_id, object_id);
+
 -- preferences
 --
 -- for preferences that apply to each request, we're using the
