From: danw Date: Thu, 10 Oct 1996 19:06:38 +0000 (+0000) Subject: added the new imembers index X-Git-Tag: MOIRA3_FINAL~22 X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/commitdiff_plain/cc5d2e37dcea97dbd3153218557ab0de67cb0ce0 added the new imembers index --- diff --git a/db/dbopt b/db/dbopt index 63ca6a6c..2a2d3299 100644 --- a/db/dbopt +++ b/db/dbopt @@ -62,6 +62,7 @@ modify i_lis_gid to btree;\g modify imembers to cbtree on member_id, member_type;\g create index i_imem_list on imembers (list_id);\g modify i_imem_list to hash;\g +create index i_imem_all on imembers (list_id, member_type, member_id, direct);\g ;\g modify strings to cbtree unique on string_id;\g create index i_str_name on strings (string);\g