Index: openacs-4/packages/xolp/tcl/xolp-activity-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/xolp/tcl/xolp-activity-procs.tcl,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/xolp/tcl/xolp-activity-procs.tcl	27 Oct 2020 15:13:10 -0000	1.8
+++ openacs-4/packages/xolp/tcl/xolp-activity-procs.tcl	10 Feb 2021 16:29:15 -0000	1.9
@@ -59,6 +59,14 @@
     "
   }
 
+  ::xo::db::require index \
+      -table xolp_activity_hierarchy_bridge \
+      -col activity_iri
+
+  ::xo::db::require index \
+      -table xolp_activity_hierarchy_bridge \
+      -col context_iri
+
   ::xolp::Activity ad_proc delete {
     -iri:required
   } {
Index: openacs-4/packages/xolp/tcl/xolp-competency-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/xolp/tcl/xolp-competency-procs.tcl,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/xolp/tcl/xolp-competency-procs.tcl	12 Apr 2019 12:09:58 -0000	1.8
+++ openacs-4/packages/xolp/tcl/xolp-competency-procs.tcl	10 Feb 2021 16:29:15 -0000	1.9
@@ -188,6 +188,14 @@
     WHERE iri = 'http://dotlrn.org/xolp/competencies/unknown';
   }
 
+  ::xo::db::require index \
+      -table xolp_competency_set_bridge \
+      -col competency_set_id
+
+  ::xo::db::require index \
+      -table xolp_competency_set_bridge \
+      -col competency_id
+
   #
   # Bridge: Connect Activities to Competencies
   #