
 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  UNIQUE  INDEX ON Pedigree(curator, curator_ped_id)
;

 CREATE  UNIQUE  INDEX ON PedigreeIndividual(ind_id, ped_id)
;


 CREATE  UNIQUE    INDEX ON PopMandLine(pop_id, line_num)
;

 CREATE  UNIQUE  INDEX ON Population(handle, loc_pop_id_upp)
;
 CREATE  UNIQUE  INDEX ON Population(handle, loc_pop_id)
;


 CREATE  UNIQUE    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  UNIQUE    INDEX ON SNPSubSNPLink(subsnp_id)
;
 CREATE  INDEX ON SNPSubSNPLink(snp_id, subsnp_id, substrand_reversed_flag)
;

 CREATE    INDEX ON SNPSubSNPLinkHistory(snp_id)
;
 CREATE  UNIQUE  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  UNIQUE    INDEX ON SNP_HGVS(snp_id, hgvs_name)
;

 CREATE  INDEX ON SNP_bitfield(link_prop_b2)
;

 CREATE  INDEX ON SubPop(subsnp_id)
;
 CREATE  INDEX ON SubPop(pop_id, subsnp_id)
;
 CREATE  INDEX ON SubPop(subpop_id)
;

 CREATE  UNIQUE    INDEX ON SubPopAllele(batch_id, pop_id, subsnp_id, type, allele, other)
;
 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  UNIQUE  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 SubSNPAcc_ins(acc_part, acc_type_ind, subsnp_id)
;




 CREATE  INDEX ON SubSNPMdFailLn(subsnp_id)
;



 CREATE  INDEX ON SubSNPPubmed(pubmed_id)
;





 CREATE  UNIQUE  INDEX ON SubmittedIndividual(submitted_ind_id)
;
 CREATE  INDEX ON SubmittedIndividual(ind_id)
;


 CREATE  UNIQUE  INDEX ON b132_ContigInfo_37_1(contig_name)
;
 CREATE  INDEX ON b132_ContigInfo_37_1(contig_label)
;
 CREATE  INDEX ON b132_ContigInfo_37_1(group_term)
;
 CREATE  UNIQUE  INDEX ON b132_ContigInfo_37_1(contig_gi)
;
 CREATE  INDEX ON b132_ContigInfo_37_1(ctg_id)
;
 CREATE  INDEX ON b132_ContigInfo_37_1(contig_name, contig_acc)
;

 CREATE  INDEX ON b132_GenomeAssemblyInfo_37_1(rep_order, assembly)
;

 CREATE  INDEX ON b132_MapLinkInfo_37_1(gi)
;

 CREATE    INDEX ON b132_MapLink_37_1(snp_id, gi)
;
 CREATE  INDEX ON b132_MapLink_37_1(gi, "offset", asn_to)
;


 CREATE  UNIQUE    INDEX ON b132_SNPChrPosOnRef_37_1(snp_id)
;

 CREATE  UNIQUE    INDEX ON b132_SNPContigLoc_37_1(snp_id, ctg_id, asn_from)
;
 CREATE  INDEX ON b132_SNPContigLoc_37_1(ctg_id, asn_from)
;
 CREATE  INDEX ON b132_SNPContigLoc_37_1(snp_type, snp_id)
;
 CREATE  INDEX ON b132_SNPContigLoc_37_1(ctg_id, snp_id)
;

 CREATE  UNIQUE    INDEX ON b132_SNPContigLocusId_37_1(locus_id, contig_acc, mrna_gi, snp_id, asn_from, allele, mrna_start)
;
 CREATE  INDEX ON b132_SNPContigLocusId_37_1(snp_id)
;

 CREATE  UNIQUE    INDEX ON b132_SNPMapInfo_37_1(snp_id, assembly)
;


 CREATE    INDEX ON dn_IND_batch_pop(pop_id)
;





 CREATE    INDEX ON dn_table_rowcount(build_id DESC , reserved_KB_spaceused DESC )
;

