Index: openacs-4/packages/acs-events/sql/oracle/timespan-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/oracle/timespan-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-events/sql/oracle/timespan-create.sql	13 Jul 2001 02:00:30 -0000	1.1
+++ openacs-4/packages/acs-events/sql/oracle/timespan-create.sql	12 Jul 2003 01:10:35 -0000	1.2
@@ -40,6 +40,8 @@
     check(start_date <= end_date)
 );
 
+create index time_intervals_start_idx on time_intervals(start_date);
+
 comment on table time_intervals is '
     A time interval is represented by two points in time.
 ';