Index: openacs-4/packages/bookmarks/sql/oracle/bookmarks-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bookmarks/sql/oracle/bookmarks-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/bookmarks/sql/oracle/bookmarks-create.sql	26 Jun 2001 01:37:24 -0000	1.3
+++ openacs-4/packages/bookmarks/sql/oracle/bookmarks-create.sql	9 Mar 2002 02:00:02 -0000	1.4
@@ -82,10 +82,15 @@
 
 
 -- We use these index for sorting the bookmarks tree
-create index bm_bookmarks_local_title_idx on bm_bookmarks (parent_id, lower(local_title), bookmark_id);
-create index bm_bookmarks_access_date_idx on bm_bookmarks (parent_id, last_access_date, bookmark_id);
 
+-- DRB: Functional indexes are an Enterprise Edition feature, so this is disabled.  What should
+-- we use?  I'm not sure at the moment because most of the queries seem to use UPPER not LOWER
+-- on local title, at least in LIKE clauses!  Making this index fairly useless (besides it is
+-- only useful if parent_id is included as a qualifier in such cases).
+-- create index bm_bookmarks_local_title_idx on bm_bookmarks (parent_id, lower(local_title), bookmark_id);
 
+create index bm_bookmarks_access_date_idx on bm_bookmarks (parent_id, last_access_date, bookmark_id);
+
 -- For connect by queries
 create index bm_bookmarks_idx1 on bm_bookmarks(bookmark_id, parent_id);
 create index bm_bookmarks_idx2 on bm_bookmarks(parent_id, bookmark_id);