Index: openacs-4/packages/tasks/sql/postgresql/tasks-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/tasks/sql/postgresql/tasks-create.sql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/tasks/sql/postgresql/tasks-create.sql	1 Mar 2006 13:49:15 -0000	1.7
+++ openacs-4/packages/tasks/sql/postgresql/tasks-create.sql	19 Oct 2006 17:05:01 -0000	1.8
@@ -126,11 +126,12 @@
 	assignee_id             integer
 );
 
+ create index t_tasks_assignee_status_idx on t_tasks(assignee_id,status_id);
+ create index t_tasks_object_idx on t_tasks(object_id);
 
 
 
 
-
 CREATE FUNCTION inline_0()
 RETURNS integer
 AS 'declare