1 CREATE UNIQUE INDEX [i_allele] ON [Allele]([allele])
4 CREATE INDEX [i_rev_allele_id] ON [Allele]([rev_allele_id])
9 CREATE INDEX [i_motif] ON [AlleleMotif]([motif_id])
13 CREATE UNIQUE CLUSTERED INDEX [ind_AllocIds_name] ON [AllocIds]([name])
17 CREATE INDEX [i_auth] ON [Author]([author])
21 CREATE UNIQUE CLUSTERED INDEX [i_ss] ON [Batch_tax_id]([batch_id])
30 CREATE INDEX [i_unigty] ON [GtyAllele]([unigty_id])
33 CREATE INDEX [gty_id_idx] ON [GtyAllele]([gty_id])
36 CREATE INDEX [i_gty_id] ON [GtyAllele]([gty_id])
41 CREATE INDEX [i_loaddate] ON [LoadHistory]([loaddate])
47 CREATE UNIQUE INDEX [i_handle_loc_method_id] ON [Method]([handle], [loc_method_id])
54 CREATE UNIQUE INDEX [i_motif] ON [Motif]([motif])
58 CREATE INDEX [i_obs] ON [ObsGenotype]([obs])
61 CREATE INDEX [i_obs_upp_fix] ON [ObsGenotype]([obs_upp_fix])
64 CREATE INDEX [i_gty_id] ON [ObsGenotype]([gty_id])
68 CREATE UNIQUE INDEX [i_pattern] ON [ObsVariation]([pattern])
71 CREATE INDEX [i_univar] ON [ObsVariation]([univar_id])
76 CREATE UNIQUE CLUSTERED INDEX [iuc_OrganismTax] ON [OrganismTax]([organism])
79 CREATE INDEX [i_tax_id] ON [OrganismTax]([tax_id])
82 CREATE INDEX [i_sp_tax] ON [OrganismTax]([species_tax_id])
85 CREATE INDEX [i_dbname] ON [OrganismTax]([database_name])
91 CREATE UNIQUE CLUSTERED INDEX [i_handle_title] ON [Publication]([handle], [title])
96 CREATE INDEX [i_tax_id] ON [SNP_tax_id]([tax_id], [snp_id])
103 CREATE UNIQUE CLUSTERED INDEX [i_code] ON [SnpValidationCode]([code])
107 CREATE INDEX [i_abbrev_orien] ON [StrandCode]([abbrev], [rs_to_ss_orien], [code])
111 CREATE UNIQUE CLUSTERED INDEX [i_comment_id] ON [SubSNPDelComm]([comment_id])
116 CREATE UNIQUE CLUSTERED INDEX [iuc_Submitter] ON [Submitter]([handle])
119 CREATE INDEX [ic_Submitter] ON [Submitter]([name])
124 CREATE UNIQUE INDEX [i_u_gty_str] ON [UniGty]([gty_str])
127 CREATE UNIQUE INDEX [i_u_allele_ids] ON [UniGty]([allele_id_1], [allele_id_2])
130 CREATE INDEX [i_allele_id_2] ON [UniGty]([allele_id_2])
134 CREATE INDEX [i_allele_id] ON [UniVariAllele]([allele_id])
138 CREATE UNIQUE INDEX [i_u_var_str] ON [UniVariation]([var_str])
141 CREATE INDEX [cv_uvid_class] ON [UniVariation]([univar_id], [subsnp_class])
146 CREATE INDEX [i_allele_id] ON [VariAllele]([allele_id])
150 CREATE UNIQUE INDEX [i_u] ON [db_DataDictionaryNew]([tab], [col_order])
162 CREATE UNIQUE CLUSTERED INDEX [i_gty] ON [dn_gty2unigty_trueSNP]([gty_id], [rev_flag])