From: zacheiss <zacheiss>
Date: Thu, 29 Nov 2007 21:46:29 +0000 (+0000)
Subject: Create index on sponsor_id column in users table.
X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/commitdiff_plain/8083db6c892ac1cf629652e05cdaa9d16807ba6a

Create index on sponsor_id column in users table.
---

diff --git a/db/dbopt.sql b/db/dbopt.sql
index 0ae04b42..64a107f0 100644
--- a/db/dbopt.sql
+++ b/db/dbopt.sql
@@ -6,6 +6,7 @@ create index i_usr_uid on  users (unix_uid);
 create index i_usr_pop on  users (pop_id);
 create index i_usr_clearid on users (clearid);
 create index i_usr_resv on users (reservations);
+create index i_usr_sponsor on users (sponsor_id);
 
 create unique index i_krb_usid on krbmap  (users_id);
 create index i_krb_str on  krbmap (string_id);