Index: openacs-4/packages/forums/sql/oracle/forums-messages-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/oracle/forums-messages-create.sql,v
diff -u -N -r1.4 -r1.5
--- openacs-4/packages/forums/sql/oracle/forums-messages-create.sql	30 Nov 2002 17:34:49 -0000	1.4
+++ openacs-4/packages/forums/sql/oracle/forums-messages-create.sql	16 Jan 2003 13:48:49 -0000	1.5
@@ -55,6 +55,10 @@
     unique (tree_sortkey, forum_id)
 );
 
+-- We do a some big queries on forum_id (thread count on index.tcl) so create a second index 
+-- ordered so it's useful for them
+create unique index forums_mess_forum_sk_un on forums_messages(forum_id, tree_sortkey);
+
 create view forums_messages_approved as
     select *
     from forums_messages