| | 1 | CREATE INDEX i_usr_login ON users (login) |
| | 2 | CREATE INDEX i_usr_name ON users (first, last) |
| | 3 | CREATE INDEX i_usr_last ON users (last, first) |
| | 4 | CREATE INDEX i_usr_uid ON users (uid) |
| | 5 | CREATE INDEX i_usr_pop ON users (pop_id) |
| | 6 | CREATE INDEX i_krb_str ON krbmap (string_id) |
| | 7 | CREATE INDEX i_mac_name ON machine (name) |
| | 8 | CREATE INDEX i_clu_name ON cluster (name) |
| | 9 | CREATE INDEX i_mcm_mach ON mcmap (mach_id) |
| | 10 | CREATE INDEX i_sho_mach ON serverhosts (mach_id) |
| | 11 | CREATE INDEX i_lis_name ON list(name) |
| | 12 | CREATE INDEX i_lis_mail ON list (maillist) |
| | 13 | CREATE INDEX i_lis_group ON list (group) |
| | 14 | CREATE INDEX i_lis_gid ON list (gid) |
| | 15 | CREATE INDEX i_imem_list ON imembers (list_id) |
| | 16 | CREATE INDEX i_str_name ON strings (string) |
| | 17 | CREATE INDEX i_nfs_mach ON nfsphys (mach_id) |
| | 18 | CREATE INDEX i_fil_name ON filesys (label) |
| | 19 | CREATE INDEX i_fil_mach ON filesys (mach_id) |
| | 20 | CREATE INDEX i_fil_phys ON filesys (phys_id) |
| | 21 | CREATE INDEX i_fil_grp ON filesys (owners) |
| | 22 | CREATE INDEX i_fil_user ON filesys (owner) |
| | 23 | CREATE INDEX i_fsg_filsys ON fsgroup (filsys_id) |
| | 24 | CREATE INDEX i_qot_fil ON quota (filsys_id) |
| | 25 | CREATE INDEX i_qot_phys ON quota (phys_id) |
| | 26 | CREATE INDEX i_pcp_mach ON printcap (mach_id) |
andersk / moira.git / blame_incremental