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 index i_mac_acctnumber on machine(account_number);
create unique index i_hal_name on hostalias (name);
create index i_hal_id on hostalias (mach_id);