 CREATE  UNIQUE  INDEX [i_allele] ON [Allele]([allele])
GO

 CREATE  INDEX [i_rev_allele_id] ON [Allele]([rev_allele_id])
GO



 CREATE  INDEX [i_motif] ON [AlleleMotif]([motif_id])
GO


 CREATE  UNIQUE  CLUSTERED  INDEX [ind_AllocIds_name] ON [AllocIds]([name])
GO


 CREATE  INDEX [i_auth] ON [Author]([author])
GO


 CREATE  UNIQUE  CLUSTERED  INDEX [i_ss] ON [Batch_tax_id]([batch_id])
GO







 CREATE  INDEX [i_unigty] ON [GtyAllele]([unigty_id])
GO

 CREATE  INDEX [gty_id_idx] ON [GtyAllele]([gty_id])
GO

 CREATE  INDEX [i_gty_id] ON [GtyAllele]([gty_id])
GO



 CREATE  INDEX [i_loaddate] ON [LoadHistory]([loaddate])
GO




 CREATE  UNIQUE  INDEX [i_handle_loc_method_id] ON [Method]([handle], [loc_method_id])
GO





 CREATE  UNIQUE  INDEX [i_motif] ON [Motif]([motif])
GO


 CREATE  INDEX [i_obs] ON [ObsGenotype]([obs])
GO

 CREATE  INDEX [i_obs_upp_fix] ON [ObsGenotype]([obs_upp_fix])
GO

 CREATE  INDEX [i_gty_id] ON [ObsGenotype]([gty_id])
GO


 CREATE  UNIQUE  INDEX [i_pattern] ON [ObsVariation]([pattern])
GO

 CREATE  INDEX [i_univar] ON [ObsVariation]([univar_id])
GO



 CREATE  UNIQUE  CLUSTERED  INDEX [iuc_OrganismTax] ON [OrganismTax]([organism])
GO

 CREATE  INDEX [i_tax_id] ON [OrganismTax]([tax_id])
GO

 CREATE  INDEX [i_sp_tax] ON [OrganismTax]([species_tax_id])
GO

 CREATE  INDEX [i_dbname] ON [OrganismTax]([database_name])
GO




 CREATE  UNIQUE  CLUSTERED  INDEX [i_handle_title] ON [Publication]([handle], [title])
GO



 CREATE  INDEX [i_tax_id] ON [SNP_tax_id]([tax_id], [snp_id])
GO





 CREATE  UNIQUE  CLUSTERED  INDEX [i_code] ON [SnpValidationCode]([code])
GO


 CREATE  INDEX [i_abbrev_orien] ON [StrandCode]([abbrev], [rs_to_ss_orien], [code])
GO


 CREATE  UNIQUE  CLUSTERED  INDEX [i_comment_id] ON [SubSNPDelComm]([comment_id])
GO



 CREATE  UNIQUE  CLUSTERED  INDEX [iuc_Submitter] ON [Submitter]([handle])
GO

 CREATE  INDEX [ic_Submitter] ON [Submitter]([name])
GO



 CREATE  UNIQUE  INDEX [i_u_gty_str] ON [UniGty]([gty_str])
GO

 CREATE  UNIQUE  INDEX [i_u_allele_ids] ON [UniGty]([allele_id_1], [allele_id_2])
GO

 CREATE  INDEX [i_allele_id_2] ON [UniGty]([allele_id_2])
GO


 CREATE  INDEX [i_allele_id] ON [UniVariAllele]([allele_id])
GO


 CREATE  UNIQUE  INDEX [i_u_var_str] ON [UniVariation]([var_str])
GO

 CREATE  INDEX [cv_uvid_class] ON [UniVariation]([univar_id], [subsnp_class])
GO



 CREATE  INDEX [i_allele_id] ON [VariAllele]([allele_id])
GO


 CREATE  UNIQUE  INDEX [i_u] ON [db_DataDictionaryNew]([tab], [col_order])
GO










 CREATE  UNIQUE  CLUSTERED  INDEX [i_gty] ON [dn_gty2unigty_trueSNP]([gty_id], [rev_flag])
GO



