From: zacheiss <zacheiss>
Date: Thu, 30 Mar 2000 22:00:42 +0000 (+0000)
Subject: create index on owner_id in machine table
X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/commitdiff_plain/3f05944f40c4206ac4dbaed6e2b0ba42b508b882

create index on owner_id in machine table
---

diff --git a/db/dbopt.sql b/db/dbopt.sql
index 7555b3ef..e93fbedc 100644
--- a/db/dbopt.sql
+++ b/db/dbopt.sql
@@ -16,6 +16,7 @@ create index i_mac_addr on machine (address);
 create index i_mac_loc on machine (location);
 create index i_mac_snet on machine (snet_id);
 create index i_mac_hwaddr on machine (hwaddr);
+create index i_mac_owner on machine (owner_id);
 
 create unique index i_hal_name on hostalias  (name);
 create index i_hal_id on hostalias (mach_id);