Index: openacs-4/packages/categories/sql/postgresql/categories-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/postgresql/categories-create.sql,v
diff -u -N -r1.12 -r1.12.2.1
--- openacs-4/packages/categories/sql/postgresql/categories-create.sql	7 Aug 2017 23:48:05 -0000	1.12
+++ openacs-4/packages/categories/sql/postgresql/categories-create.sql	6 Oct 2022 16:34:33 -0000	1.12.2.1
@@ -209,6 +209,10 @@
 
 create unique index cat_object_map_ix on category_object_map(object_id, category_id);
 
+-- create indices on FK constraints
+create index category_object_map_object_id_idx on category_object_map(object_id);
+create index category_object_map_category_id_idx on category_object_map(category_id);
+
 comment on table category_object_map is '
   Maps categories to objects and thus categorizes and object.
 ';