1 CREATE NONCLUSTERED INDEX [i_allele] ON [Allele] ([allele] ASC)
\r
3 CREATE NONCLUSTERED INDEX [i_rev_allele_id] ON [Allele] ([rev_allele_id] ASC)
\r
7 CREATE NONCLUSTERED INDEX [i_motif] ON [AlleleMotif] ([motif_id] ASC)
\r
10 CREATE CLUSTERED INDEX [ind_AllocIds_name] ON [AllocIds] ([name] ASC)
\r
13 CREATE NONCLUSTERED INDEX [i_auth] ON [Author] ([author] ASC)
\r
16 CREATE CLUSTERED INDEX [i_ss] ON [Batch_tax_id] ([batch_id] ASC)
\r
24 CREATE NONCLUSTERED INDEX [i_unigty] ON [GtyAllele] ([unigty_id] ASC)
\r
26 CREATE NONCLUSTERED INDEX [gty_id_idx] ON [GtyAllele] ([gty_id] ASC)
\r
28 CREATE NONCLUSTERED INDEX [i_gty_id] ON [GtyAllele] ([gty_id] ASC)
\r
32 CREATE NONCLUSTERED INDEX [i_loaddate] ON [LoadHistory] ([loaddate] ASC)
\r
37 CREATE NONCLUSTERED INDEX [i_handle_loc_method_id] ON [Method] ([handle] ASC,[loc_method_id] ASC)
\r
43 CREATE NONCLUSTERED INDEX [i_motif] ON [Motif] ([motif] ASC)
\r
46 CREATE NONCLUSTERED INDEX [i_obs] ON [ObsGenotype] ([obs] ASC)
\r
48 CREATE NONCLUSTERED INDEX [i_obs_upp_fix] ON [ObsGenotype] ([obs_upp_fix] ASC)
\r
50 CREATE NONCLUSTERED INDEX [i_gty_id] ON [ObsGenotype] ([gty_id] ASC)
\r
53 CREATE NONCLUSTERED INDEX [i_pattern] ON [ObsVariation] ([pattern] ASC)
\r
55 CREATE NONCLUSTERED INDEX [i_univar] ON [ObsVariation] ([univar_id] ASC)
\r
59 CREATE CLUSTERED INDEX [iuc_OrganismTax] ON [OrganismTax] ([organism] ASC)
\r
61 CREATE NONCLUSTERED INDEX [i_tax_id] ON [OrganismTax] ([tax_id] ASC)
\r
63 CREATE NONCLUSTERED INDEX [i_sp_tax] ON [OrganismTax] ([species_tax_id] ASC)
\r
65 CREATE NONCLUSTERED INDEX [i_dbname] ON [OrganismTax] ([database_name] ASC)
\r
70 CREATE CLUSTERED INDEX [i_handle_title] ON [Publication] ([handle] ASC,[title] ASC)
\r
74 CREATE NONCLUSTERED INDEX [i_tax_id] ON [SNP_tax_id] ([tax_id] ASC,[snp_id] ASC)
\r
80 CREATE CLUSTERED INDEX [i_code] ON [SnpValidationCode] ([code] ASC)
\r
83 CREATE NONCLUSTERED INDEX [i_abbrev_orien] ON [StrandCode] ([abbrev] ASC,[rs_to_ss_orien] ASC,[code] ASC)
\r
86 CREATE CLUSTERED INDEX [i_comment_id] ON [SubSNPDelComm] ([comment_id] ASC)
\r
90 CREATE CLUSTERED INDEX [iuc_Submitter] ON [Submitter] ([handle] ASC)
\r
92 CREATE NONCLUSTERED INDEX [ic_Submitter] ON [Submitter] ([name] ASC)
\r
96 CREATE NONCLUSTERED INDEX [i_u_gty_str] ON [UniGty] ([gty_str] ASC)
\r
98 CREATE NONCLUSTERED INDEX [i_u_allele_ids] ON [UniGty] ([allele_id_1] ASC,[allele_id_2] ASC)
\r
100 CREATE NONCLUSTERED INDEX [i_allele_id_2] ON [UniGty] ([allele_id_2] ASC)
\r
103 CREATE NONCLUSTERED INDEX [i_allele_id] ON [UniVariAllele] ([allele_id] ASC)
\r
106 CREATE NONCLUSTERED INDEX [i_u_var_str] ON [UniVariation] ([var_str] ASC)
\r
108 CREATE NONCLUSTERED INDEX [cv_uvid_class] ON [UniVariation] ([univar_id] ASC,[subsnp_class] ASC)
\r
112 CREATE NONCLUSTERED INDEX [i_allele_id] ON [VariAllele] ([allele_id] ASC)
\r
123 CREATE CLUSTERED INDEX [i_gty] ON [dn_gty2unigty_trueSNP] ([gty_id] ASC,[rev_flag] ASC)
\r