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.40 -r1.41
--- openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql	24 May 2002 01:58:46 -0000	1.40
+++ openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql	7 Jun 2002 04:42:49 -0000	1.41
@@ -244,6 +244,8 @@
 	value			varchar(200) 
 );
 
+create index p_element__prms_elem_id_idx on portal_element_parameters (element_id);
+create index p_element_prms_elem_key_idx on portal_element_parameters (element_id, key);
 
 -- This table maps the datasources that are available for portals to
 -- bind to (i.e. creating a PE). This table is required since some DSs
