X-Git-Url: https://git.donarmstrong.com/?p=dbsnp.git;a=blobdiff_plain;f=schema%2Fhuman_9606_schema%2Fhuman_9606_index.sql;fp=schema%2Fhuman_9606_schema%2Fhuman_9606_index.sql;h=27bf6fc8d335900d287c2093352683ef1a6cfe61;hp=c935c662f03365e1eb3d2b27dc7709b16260e462;hb=0171eebd400d97cb96607bf112f049d6b30f9b77;hpb=71dd006316add35b0740e9ecc8f81b67c0c3f736

diff --git a/schema/human_9606_schema/human_9606_index.sql b/schema/human_9606_schema/human_9606_index.sql
index c935c66..27bf6fc 100644
--- a/schema/human_9606_schema/human_9606_index.sql
+++ b/schema/human_9606_schema/human_9606_index.sql
@@ -55,9 +55,7 @@ GO
 CREATE NONCLUSTERED INDEX [i_handle_loc_pop_id] ON [Population] ([handle] ASC,[loc_pop_id] ASC)
 GO
 
-CREATE CLUSTERED INDEX [i_rsL] ON [RsMergeArch] ([rsLow] ASC)
-GO
-CREATE NONCLUSTERED INDEX [i_rsH] ON [RsMergeArch] ([rsHigh] ASC)
+CREATE NONCLUSTERED INDEX [ndx_RsMergeArch_HI] ON [RsMergeArch] ([rsHigh] ASC)
 GO
 
 CREATE CLUSTERED INDEX [i_rs] ON [SNP] ([snp_id] ASC)
@@ -71,6 +69,8 @@ GO
 
 
 
+CREATE CLUSTERED INDEX [i_rs_hgvs] ON [SNPClinSig] ([hgvs_g] ASC,[snp_id] ASC)
+GO
 
 
 
@@ -143,6 +143,8 @@ CREATE NONCLUSTERED INDEX [i_bid_ss] ON [SubSNP] ([batch_id] ASC,[subsnp_id] ASC
 GO
 CREATE NONCLUSTERED INDEX [i_var] ON [SubSNP] ([variation_id] ASC,[subsnp_id] ASC)
 GO
+CREATE NONCLUSTERED INDEX [i_ss_bid_loc] ON [SubSNP] ([subsnp_id] ASC,[batch_id] ASC,[loc_snp_id] ASC)
+GO
 
 CREATE NONCLUSTERED INDEX [i_acc_part_ind] ON [SubSNPAcc_ins] ([acc_part] ASC,[acc_type_ind] ASC,[subsnp_id] ASC)
 GO
@@ -168,65 +170,38 @@ CREATE NONCLUSTERED INDEX [i_ind] ON [SubmittedIndividual] ([ind_id] ASC)
 GO
 
 
-CREATE NONCLUSTERED INDEX [i_asm] ON [b135_ContigInfo_37_3] ([asm_acc] ASC,[asm_version] ASC,[contig_start] ASC,[contig_end] ASC,[chr_gi] ASC)
-GO
-CREATE NONCLUSTERED INDEX [i_asm_chr_ctg] ON [b135_ContigInfo_37_3] ([asm_acc] ASC,[asm_version] ASC,[chr_gi] ASC,[contig_start] ASC,[contig_end] ASC)
-GO
-CREATE NONCLUSTERED INDEX [idxContigLabel] ON [b135_ContigInfo_37_3] ([contig_label] ASC)
-GO
-CREATE NONCLUSTERED INDEX [ndx_ContigInfo_pc_37_3] ON [b135_ContigInfo_37_3] ([placement_status] ASC,[ctg_id] ASC)
-GO
-
 
-CREATE CLUSTERED INDEX [i_gi] ON [b135_MapLinkInfo_37_3] ([gi] ASC)
+CREATE NONCLUSTERED INDEX [i_asm_chr_ctg] ON [b137_ContigInfo] ([asm_acc] ASC,[asm_version] ASC,[chr_gi] ASC,[contig_start] ASC,[contig_end] ASC)
 GO
 
-CREATE CLUSTERED INDEX [i_rs_gi_pos] ON [b135_MapLink_37_3] ([snp_id] ASC,[gi] ASC,[offset] ASC)
-GO
-CREATE NONCLUSTERED INDEX [i_src] ON [b135_MapLink_37_3] ([source] ASC,[snp_type] ASC,[snp_id] ASC,[gi] ASC,[offset] ASC,[asn_to] ASC)
+CREATE CLUSTERED INDEX [i_rs_gi_pos] ON [b137_MapLink] ([snp_id] ASC,[gi] ASC,[offset] ASC)
 GO
 
-CREATE CLUSTERED INDEX [i_gi] ON [b135_ProteinInfo_37_3] ([gi] ASC)
-GO
 
-CREATE CLUSTERED INDEX [i_rs_pos] ON [b135_Remapped_37_3] ([snp_id] ASC,[src_gi] ASC,[src_from] ASC,[tgt_gi] ASC)
-GO
-CREATE NONCLUSTERED INDEX [i_tgt_gi] ON [b135_Remapped_37_3] ([tgt_gi] ASC,[snp_type] ASC,[snp_id] ASC)
+CREATE CLUSTERED INDEX [i_gi] ON [b137_MapLinkInfo] ([gi] ASC)
 GO
 
-CREATE CLUSTERED INDEX [i_rs] ON [b135_SNPChrPosOnRef_37_3] ([snp_id] ASC)
+CREATE CLUSTERED INDEX [i_gi] ON [b137_ProteinInfo] ([gi] ASC)
 GO
 
-CREATE CLUSTERED INDEX [i_rs] ON [b135_SNPContigLoc_37_3] ([snp_id] ASC,[ctg_id] ASC,[asn_from] ASC)
-GO
-CREATE NONCLUSTERED INDEX [i_ctg] ON [b135_SNPContigLoc_37_3] ([ctg_id] ASC)
-GO
-CREATE NONCLUSTERED INDEX [i_snp] ON [b135_SNPContigLoc_37_3] ([snp_type] ASC,[snp_id] ASC)
-GO
-CREATE NONCLUSTERED INDEX [idxAsnFrom] ON [b135_SNPContigLoc_37_3] ([asn_from] ASC)
-GO
 
-CREATE CLUSTERED INDEX [i_rsCtgMrna] ON [b135_SNPContigLocusId_37_3] ([snp_id] ASC,[contig_acc] ASC,[asn_from] ASC,[locus_id] ASC,[allele] ASC,[mrna_start] ASC,[mrna_gi] ASC)
-GO
-CREATE NONCLUSTERED INDEX [i_rs] ON [b135_SNPContigLocusId_37_3] ([snp_id] ASC)
+CREATE CLUSTERED INDEX [i_rs] ON [b137_SNPChrPosOnRef] ([snp_id] ASC)
 GO
 
-CREATE CLUSTERED INDEX [i_rs_gi] ON [b135_SNPContigProtein_37_3] ([snp_id] ASC,[contig_gi] ASC,[contig_start] ASC)
+CREATE NONCLUSTERED INDEX [i_pos] ON [b137_SNPContigLoc] ([ctg_id] ASC,[asn_from] ASC,[snp_id] ASC)
 GO
 
-CREATE CLUSTERED INDEX [i_rs_asm] ON [b135_SNPMapInfo_37_3] ([snp_id] ASC,[asm_acc] ASC)
-GO
-CREATE NONCLUSTERED INDEX [i_asm] ON [b135_SNPMapInfo_37_3] ([asm_acc] ASC,[asm_version] ASC)
+CREATE CLUSTERED INDEX [i_rsCtgMrna] ON [b137_SNPContigLocusId] ([snp_id] ASC,[contig_acc] ASC,[asn_from] ASC,[locus_id] ASC,[allele] ASC,[mrna_start] ASC,[mrna_gi] ASC)
 GO
-CREATE NONCLUSTERED INDEX [iuc_rs_assembly_37_3] ON [b135_SNPMapInfo_37_3] ([asm_acc] ASC,[weight] ASC,[snp_id] ASC)
+CREATE NONCLUSTERED INDEX [i_rs] ON [b137_SNPContigLocusId] ([snp_id] ASC)
 GO
 
-CREATE CLUSTERED INDEX [i_rs_pos] ON [b135_SNPMapLinkProtein_37_3] ([snp_id] ASC,[mrna_gi] ASC,[mrna_start] ASC,[mrna_stop] ASC)
-GO
-CREATE NONCLUSTERED INDEX [i_ctg] ON [b135_SNPMapLinkProtein_37_3] ([ctg_gi] ASC,[mrna_gi] ASC,[snp_id] ASC)
+
+CREATE CLUSTERED INDEX [i_rs_asm] ON [b137_SNPMapInfo] ([snp_id] ASC,[asm_acc] ASC)
 GO
 
 
+
 CREATE CLUSTERED INDEX [i_pid] ON [dn_IND_batch_pop] ([pop_id] ASC)
 GO