2 CREATE INDEX ON Batch(tax_id)
4 CREATE INDEX ON Batch(submitted_time)
6 CREATE INDEX ON Batch(handle, loc_batch_id)
8 CREATE INDEX ON Batch(pop_id)
10 CREATE INDEX ON Batch(success_rate_int)
12 CREATE INDEX ON Batch(method_id)
14 CREATE INDEX ON Batch(loc_batch_id_upp)
16 CREATE INDEX ON Batch(last_updated_time)
19 CREATE INDEX ON BatchCita(pub_id)
23 CREATE INDEX ON BatchCultivar(line)
27 CREATE INDEX ON BatchStrain(line)
40 CREATE UNIQUE INDEX ON Pedigree(curator, curator_ped_id)
43 CREATE UNIQUE INDEX ON PedigreeIndividual(ind_id, ped_id)
47 CREATE UNIQUE INDEX ON PopMandLine(pop_id, line_num)
50 CREATE UNIQUE INDEX ON Population(handle, loc_pop_id_upp)
52 CREATE UNIQUE INDEX ON Population(handle, loc_pop_id)
56 CREATE UNIQUE INDEX ON SNP(snp_id)
58 CREATE INDEX ON SNP(exemplar_subsnp_id, snp_id)
61 CREATE INDEX ON SNP3D(snp_id)
68 CREATE INDEX ON SNPHistory(history_create_time)
72 CREATE UNIQUE INDEX ON SNPSubSNPLink(subsnp_id)
74 CREATE INDEX ON SNPSubSNPLink(snp_id, subsnp_id, substrand_reversed_flag)
77 CREATE INDEX ON SNPSubSNPLinkHistory(snp_id)
79 CREATE UNIQUE INDEX ON SNPSubSNPLinkHistory(subsnp_id, snp_id)
81 CREATE INDEX ON SNPSubSNPLinkHistory(build_id)
83 CREATE INDEX ON SNPSubSNPLinkHistory(build_id_when_history_made)
86 CREATE INDEX ON SNPVal(snp_id)
89 CREATE UNIQUE INDEX ON SNP_HGVS(snp_id, hgvs_name)
92 CREATE INDEX ON SNP_bitfield(link_prop_b2)
95 CREATE INDEX ON SubPop(subsnp_id)
97 CREATE INDEX ON SubPop(pop_id, subsnp_id)
99 CREATE INDEX ON SubPop(subpop_id)
102 CREATE UNIQUE INDEX ON SubPopAllele(batch_id, pop_id, subsnp_id, type, allele, other)
104 CREATE INDEX ON SubPopAllele(freq)
106 CREATE INDEX ON SubPopAllele(freq_max)
108 CREATE INDEX ON SubPopAllele(freq_min)
110 CREATE INDEX ON SubPopAllele(subsnp_id)
112 CREATE INDEX ON SubPopAllele(type)
114 CREATE INDEX ON SubPopAllele(last_updated_time)
116 CREATE INDEX ON SubPopAllele(allele_id)
118 CREATE INDEX ON SubPopAllele(subpop_id)
120 CREATE UNIQUE INDEX ON SubPopAllele(subpop_id, type, allele, other)
123 CREATE INDEX ON SubPopGty(subpop_id)
125 CREATE INDEX ON SubPopGty(gty_id)
128 CREATE INDEX ON SubSNP(loc_snp_id_upp, subsnp_id)
130 CREATE INDEX ON SubSNP(batch_id, subsnp_id)
133 CREATE INDEX ON SubSNPAcc_ins(acc_part, acc_type_ind, subsnp_id)
139 CREATE INDEX ON SubSNPMdFailLn(subsnp_id)
144 CREATE INDEX ON SubSNPPubmed(pubmed_id)
151 CREATE UNIQUE INDEX ON SubmittedIndividual(submitted_ind_id)
153 CREATE INDEX ON SubmittedIndividual(ind_id)
157 CREATE UNIQUE INDEX ON b132_ContigInfo_37_1(contig_name)
159 CREATE INDEX ON b132_ContigInfo_37_1(contig_label)
161 CREATE INDEX ON b132_ContigInfo_37_1(group_term)
163 CREATE UNIQUE INDEX ON b132_ContigInfo_37_1(contig_gi)
165 CREATE INDEX ON b132_ContigInfo_37_1(ctg_id)
167 CREATE INDEX ON b132_ContigInfo_37_1(contig_name, contig_acc)
170 CREATE INDEX ON b132_GenomeAssemblyInfo_37_1(rep_order, assembly)
173 CREATE INDEX ON b132_MapLinkInfo_37_1(gi)
176 CREATE INDEX ON b132_MapLink_37_1(snp_id, gi)
178 CREATE INDEX ON b132_MapLink_37_1(gi, "offset", asn_to)
182 CREATE UNIQUE INDEX ON b132_SNPChrPosOnRef_37_1(snp_id)
185 CREATE UNIQUE INDEX ON b132_SNPContigLoc_37_1(snp_id, ctg_id, asn_from)
187 CREATE INDEX ON b132_SNPContigLoc_37_1(ctg_id, asn_from)
189 CREATE INDEX ON b132_SNPContigLoc_37_1(snp_type, snp_id)
191 CREATE INDEX ON b132_SNPContigLoc_37_1(ctg_id, snp_id)
194 CREATE UNIQUE INDEX ON b132_SNPContigLocusId_37_1(locus_id, contig_acc, mrna_gi, snp_id, asn_from, allele, mrna_start)
196 CREATE INDEX ON b132_SNPContigLocusId_37_1(snp_id)
199 CREATE UNIQUE INDEX ON b132_SNPMapInfo_37_1(snp_id, assembly)
203 CREATE INDEX ON dn_IND_batch_pop(pop_id)
210 CREATE INDEX ON dn_table_rowcount(build_id DESC , reserved_KB_spaceused DESC )