create index on owner_id in machine table

diff --git a/db/dbopt.sql b/db/dbopt.sql
index 7555b3ef42592cd67420a02c8882327e35e3cd9d..e93fbedca81381a08d5362ccdb2d51bc5a2de208 100644 (file)
--- 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);