[dbsnp.git] / schema / human_9606_schema / human_9606_index.sql

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

 CREATE  INDEX [i_submitted_time] ON [Batch]([submitted_time])
GO

 CREATE  INDEX [i_handle_loc_batch_id] ON [Batch]([handle], [loc_batch_id])
GO

 CREATE  INDEX [i_pop_id] ON [Batch]([pop_id])
GO

 CREATE  INDEX [i_success_rate_int] ON [Batch]([success_rate_int])
GO

 CREATE  INDEX [i_method_id] ON [Batch]([method_id])
GO

 CREATE  INDEX [i_lbid_u] ON [Batch]([loc_batch_id_upp])
GO

 CREATE  INDEX [i_last_updated] ON [Batch]([last_updated_time])
GO


 CREATE  INDEX [i_pub_id] ON [BatchCita]([pub_id])
GO



 CREATE  INDEX [i_BatchCultivar2] ON [BatchCultivar]([line])
GO



 CREATE  INDEX [i_strain] ON [BatchStrain]([line])
GO












 CREATE  UNIQUE  INDEX [i_curator_ped_id] ON [Pedigree]([curator], [curator_ped_id])
GO


 CREATE  UNIQUE  INDEX [i_ind_ped] ON [PedigreeIndividual]([ind_id], [ped_id])
GO



 CREATE  UNIQUE  CLUSTERED  INDEX [i_pid_line_num] ON [PopMandLine]([pop_id], [line_num])
GO


 CREATE  UNIQUE  INDEX [i_handle_loc_pop_id_upp] ON [Population]([handle], [loc_pop_id_upp])
GO

 CREATE  UNIQUE  INDEX [i_handle_loc_pop_id] ON [Population]([handle], [loc_pop_id])
GO



 CREATE  UNIQUE  CLUSTERED  INDEX [i_rs] ON [SNP]([snp_id])
GO

 CREATE  INDEX [i_exemplarSs] ON [SNP]([exemplar_subsnp_id], [snp_id])
GO


 CREATE  INDEX [i_rs] ON [SNP3D]([snp_id])
GO






 CREATE  INDEX [i_hist_time] ON [SNPHistory]([history_create_time])
GO



 CREATE  UNIQUE  CLUSTERED  INDEX [i_ss] ON [SNPSubSNPLink]([subsnp_id])
GO

 CREATE  INDEX [i_rs] ON [SNPSubSNPLink]([snp_id], [subsnp_id], [substrand_reversed_flag])
GO


 CREATE  CLUSTERED  INDEX [i_snp_id] ON [SNPSubSNPLinkHistory]([snp_id])
GO

 CREATE  UNIQUE  INDEX [i_ss_rs] ON [SNPSubSNPLinkHistory]([subsnp_id], [snp_id])
GO

 CREATE  INDEX [i_build_id] ON [SNPSubSNPLinkHistory]([build_id])
GO

 CREATE  INDEX [i_build_id_when_history_made] ON [SNPSubSNPLinkHistory]([build_id_when_history_made])
GO


 CREATE  INDEX [i_rs] ON [SNPVal]([snp_id])
GO


 CREATE  UNIQUE  CLUSTERED  INDEX [i_rs_hgvs] ON [SNP_HGVS]([snp_id], [hgvs_name])
GO


 CREATE  INDEX [i_link_prop_b2] ON [SNP_bitfield]([link_prop_b2])
GO


 CREATE  INDEX [i_ss] ON [SubPop]([subsnp_id])
GO

 CREATE  INDEX [i_pop_ss] ON [SubPop]([pop_id], [subsnp_id])
GO

 CREATE  INDEX [i_subpop_id] ON [SubPop]([subpop_id])
GO


 CREATE  UNIQUE  CLUSTERED  INDEX [iuc_SubPopAllele] ON [SubPopAllele]([batch_id], [pop_id], [subsnp_id], [type], [allele], [other])
GO

 CREATE  INDEX [iSubPopAllele1] ON [SubPopAllele]([freq])
GO

 CREATE  INDEX [iSubPopAllele2] ON [SubPopAllele]([freq_max])
GO

 CREATE  INDEX [iSubPopAllele3] ON [SubPopAllele]([freq_min])
GO

 CREATE  INDEX [i_subsnp_id] ON [SubPopAllele]([subsnp_id])
GO

 CREATE  INDEX [i_type] ON [SubPopAllele]([type])
GO

 CREATE  INDEX [i_last_updated_time] ON [SubPopAllele]([last_updated_time])
GO

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

 CREATE  INDEX [i_subpop_id] ON [SubPopAllele]([subpop_id])
GO

 CREATE  UNIQUE  INDEX [i_sp_ale] ON [SubPopAllele]([subpop_id], [type], [allele], [other])
GO


 CREATE  INDEX [i_subpop_id] ON [SubPopGty]([subpop_id])
GO

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


 CREATE  INDEX [i_loc_snp] ON [SubSNP]([loc_snp_id_upp], [subsnp_id])
GO

 CREATE  INDEX [i_bid_ss] ON [SubSNP]([batch_id], [subsnp_id])
GO


 CREATE  INDEX [i_acc_part_ind] ON [SubSNPAcc_ins]([acc_part], [acc_type_ind], [subsnp_id])
GO





 CREATE  INDEX [i_subsnp_id] ON [SubSNPMdFailLn]([subsnp_id])
GO




 CREATE  INDEX [i_pmid] ON [SubSNPPubmed]([pubmed_id])
GO






 CREATE  UNIQUE  INDEX [i_submitted_ind_id] ON [SubmittedIndividual]([submitted_ind_id])
GO

 CREATE  INDEX [i_ind] ON [SubmittedIndividual]([ind_id])
GO



 CREATE  UNIQUE  INDEX [idxContigName] ON [b132_ContigInfo_37_1]([contig_name])
GO

 CREATE  INDEX [idxContigLabel] ON [b132_ContigInfo_37_1]([contig_label])
GO

 CREATE  INDEX [idxGroupTerm] ON [b132_ContigInfo_37_1]([group_term])
GO

 CREATE  UNIQUE  INDEX [idxCtgGi] ON [b132_ContigInfo_37_1]([contig_gi])
GO

 CREATE  INDEX [idxContigId] ON [b132_ContigInfo_37_1]([ctg_id])
GO

 CREATE  INDEX [idxContigNameAcc] ON [b132_ContigInfo_37_1]([contig_name], [contig_acc])
GO


 CREATE  INDEX [i_order_assem_132] ON [b132_GenomeAssemblyInfo_37_1]([rep_order], [assembly])
GO


 CREATE  INDEX [idxGi] ON [b132_MapLinkInfo_37_1]([gi])
GO


 CREATE  CLUSTERED  INDEX [i_rs_gi_pos] ON [b132_MapLink_37_1]([snp_id], [gi])
GO

 CREATE  INDEX [idxSnpLoc] ON [b132_MapLink_37_1]([gi], [offset], [asn_to])
GO



 CREATE  UNIQUE  CLUSTERED  INDEX [i_rs] ON [b132_SNPChrPosOnRef_37_1]([snp_id])
GO


 CREATE  UNIQUE  CLUSTERED  INDEX [i_rs] ON [b132_SNPContigLoc_37_1]([snp_id], [ctg_id], [asn_from])
GO

 CREATE  INDEX [i_ctgPos] ON [b132_SNPContigLoc_37_1]([ctg_id], [asn_from])
GO

 CREATE  INDEX [idxSnpId] ON [b132_SNPContigLoc_37_1]([snp_type], [snp_id])
GO

 CREATE  INDEX [iCtgSnp] ON [b132_SNPContigLoc_37_1]([ctg_id], [snp_id])
GO


 CREATE  UNIQUE  CLUSTERED  INDEX [i_rsCtgMrna] ON [b132_SNPContigLocusId_37_1]([locus_id], [contig_acc], [mrna_gi], [snp_id], [asn_from], [allele], [mrna_start])
GO

 CREATE  INDEX [i_rs] ON [b132_SNPContigLocusId_37_1]([snp_id])
GO


 CREATE  UNIQUE  CLUSTERED  INDEX [i_rs] ON [b132_SNPMapInfo_37_1]([snp_id], [assembly])
GO



 CREATE  CLUSTERED  INDEX [i_pid] ON [dn_IND_batch_pop]([pop_id])
GO






 CREATE  CLUSTERED  INDEX [i_b_size] ON [dn_table_rowcount]([build_id] DESC , [reserved_KB_spaceused] DESC )
GO