
CREATE INDEX ON Batch (tax_id);
CREATE INDEX ON Batch (submitted_time);
CREATE INDEX ON Batch (handle,loc_batch_id);
CREATE INDEX ON Batch (pop_id);
CREATE INDEX ON Batch (success_rate_int);
CREATE INDEX ON Batch (method_id);
CREATE INDEX ON Batch (loc_batch_id_upp);
CREATE INDEX ON Batch (last_updated_time);
CREATE INDEX ON BatchCita (pub_id);
CREATE INDEX ON BatchCultivar (line);
CREATE INDEX ON BatchStrain (line);
CREATE INDEX ON FreqSummaryBySsPop (subsnp_id,pop_id);
CREATE INDEX ON Pedigree (curator,curator_ped_id);
CREATE INDEX ON PedigreeIndividual (ind_id,ped_id);
CREATE INDEX ON PopMandLine (pop_id,line_num);
CREATE INDEX ON Population (handle,loc_pop_id_upp);
CREATE INDEX ON Population (handle,loc_pop_id);
CREATE INDEX ON RsMergeArch (rsLow);
CREATE INDEX ON RsMergeArch (rsHigh);
CREATE INDEX ON SNP (snp_id);
CREATE INDEX ON SNP (exemplar_subsnp_id,snp_id);
CREATE INDEX ON SNP3D (snp_id);
CREATE INDEX ON SNPHistory (history_create_time);
CREATE INDEX ON SNPPubmed (snp_id,subsnp_id,pubmed_id,type);
CREATE INDEX ON SNPSubSNPLink (subsnp_id);
CREATE INDEX ON SNPSubSNPLink (snp_id,subsnp_id,substrand_reversed_flag);
CREATE INDEX ON SNPSubSNPLinkHistory (snp_id);
CREATE INDEX ON SNPSubSNPLinkHistory (subsnp_id,snp_id);
CREATE INDEX ON SNPSubSNPLinkHistory (build_id);
CREATE INDEX ON SNPSubSNPLinkHistory (build_id_when_history_made);
CREATE INDEX ON SNPVal (snp_id);
CREATE INDEX ON SNP_HGVS (snp_id,hgvs_name);
CREATE INDEX ON SNP_bitfield (link_prop_b2,snp_id);
CREATE INDEX ON SubPop (subsnp_id);
CREATE INDEX ON SubPop (pop_id,subsnp_id);
CREATE INDEX ON SubPop (subpop_id);
CREATE INDEX ON SubPopAllele (batch_id,subsnp_id,pop_id,allele,other,type);
CREATE INDEX ON SubPopAllele (freq);
CREATE INDEX ON SubPopAllele (freq_max);
CREATE INDEX ON SubPopAllele (freq_min);
CREATE INDEX ON SubPopAllele (subsnp_id);
CREATE INDEX ON SubPopAllele (type);
CREATE INDEX ON SubPopAllele (last_updated_time);
CREATE INDEX ON SubPopAllele (allele_id);
CREATE INDEX ON SubPopAllele (subpop_id);
CREATE INDEX ON SubPopAllele (subpop_id,type,allele,other);
CREATE INDEX ON SubPopGty (subpop_id);
CREATE INDEX ON SubPopGty (gty_id);
CREATE INDEX ON SubSNP (loc_snp_id_upp,subsnp_id);
CREATE INDEX ON SubSNP (batch_id,subsnp_id);
CREATE INDEX ON SubSNP (variation_id,subsnp_id);
CREATE INDEX ON SubSNPAcc_ins (acc_part,acc_type_ind,subsnp_id);
CREATE INDEX ON SubSNPMdFailLn (subsnp_id);
CREATE INDEX ON SubSNPPubmed (pubmed_id);
CREATE INDEX ON SubmittedIndividual (submitted_ind_id);
CREATE INDEX ON SubmittedIndividual (ind_id);
CREATE INDEX ON b135_ContigInfo_37_3 (asm_acc,asm_version,contig_start,contig_end,chr_gi);
CREATE INDEX ON b135_ContigInfo_37_3 (asm_acc,asm_version,chr_gi,contig_start,contig_end);
CREATE INDEX ON b135_ContigInfo_37_3 (contig_label);
CREATE INDEX ON b135_ContigInfo_37_3 (placement_status,ctg_id);
CREATE INDEX ON b135_MapLinkInfo_37_3 (gi);
CREATE INDEX ON b135_MapLink_37_3 (snp_id,gi,offset);
CREATE INDEX ON b135_MapLink_37_3 (source,snp_type,snp_id,gi,offset,asn_to);
CREATE INDEX ON b135_ProteinInfo_37_3 (gi);
CREATE INDEX ON b135_Remapped_37_3 (snp_id,src_gi,src_from,tgt_gi);
CREATE INDEX ON b135_Remapped_37_3 (tgt_gi,snp_type,snp_id);
CREATE INDEX ON b135_SNPChrPosOnRef_37_3 (snp_id);
CREATE INDEX ON b135_SNPContigLoc_37_3 (snp_id,ctg_id,asn_from);
CREATE INDEX ON b135_SNPContigLoc_37_3 (ctg_id);
CREATE INDEX ON b135_SNPContigLoc_37_3 (snp_type,snp_id);
CREATE INDEX ON b135_SNPContigLoc_37_3 (asn_from);
CREATE INDEX ON b135_SNPContigLocusId_37_3 (snp_id,contig_acc,asn_from,locus_id,allele,mrna_start,mrna_gi);
CREATE INDEX ON b135_SNPContigLocusId_37_3 (snp_id);
CREATE INDEX ON b135_SNPContigProtein_37_3 (snp_id,contig_gi,contig_start);
CREATE INDEX ON b135_SNPMapInfo_37_3 (snp_id,asm_acc);
CREATE INDEX ON b135_SNPMapInfo_37_3 (asm_acc,asm_version);
CREATE INDEX ON b135_SNPMapInfo_37_3 (asm_acc,weight,snp_id);
CREATE INDEX ON b135_SNPMapLinkProtein_37_3 (snp_id,mrna_gi,mrna_start,mrna_stop);
CREATE INDEX ON b135_SNPMapLinkProtein_37_3 (ctg_gi,mrna_gi,snp_id);
CREATE INDEX ON dn_IND_batch_pop (pop_id);
CREATE INDEX ON dn_table_rowcount (build_id DESC,reserved_KB_spaceused DESC);
