Index: openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql,v
diff -u -r1.47 -r1.48
--- openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql	15 May 2007 20:14:47 -0000	1.47
+++ openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql	7 Aug 2017 23:48:12 -0000	1.48
@@ -158,7 +158,9 @@
     template_id                     constraint template_id_fk
                                     references portals (portal_id)
 );
+create index portals_template_id_idx on portals(template_id);
 
+
 -- Support for multi-page portals (think my.yahoo.com)
 create table portal_pages (
     page_id                         constraint portal_pages_page_id_fk