CREATE INDEX ON GtyAllele (gty_id);
CREATE INDEX ON GtyAllele (gty_id);
CREATE INDEX ON LoadHistory (loaddate);
-CREATE INDEX ON Method (handle ASC,loc_method_id);
+CREATE INDEX ON Method (handle,loc_method_id);
CREATE INDEX ON Motif (motif);
CREATE INDEX ON ObsGenotype (obs);
CREATE INDEX ON ObsGenotype (obs_upp_fix);
CREATE INDEX ON OrganismTax (tax_id);
CREATE INDEX ON OrganismTax (species_tax_id);
CREATE INDEX ON OrganismTax (database_name);
-CREATE INDEX ON Publication (handle ASC,title);
-CREATE INDEX ON SNP_tax_id (tax_id ASC,snp_id);
+CREATE INDEX ON Publication (handle,title);
+CREATE INDEX ON SNP_tax_id (tax_id,snp_id);
CREATE INDEX ON SnpValidationCode (code);
-CREATE INDEX ON StrandCode (abbrev ASC,rs_to_ss_orien ASC,code);
+CREATE INDEX ON StrandCode (abbrev,rs_to_ss_orien,code);
CREATE INDEX ON SubSNPDelComm (comment_id);
CREATE INDEX ON Submitter (handle);
CREATE INDEX ON Submitter (name);
CREATE INDEX ON UniGty (gty_str);
-CREATE INDEX ON UniGty (allele_id_1 ASC,allele_id_2);
+CREATE INDEX ON UniGty (allele_id_1,allele_id_2);
CREATE INDEX ON UniGty (allele_id_2);
CREATE INDEX ON UniVariAllele (allele_id);
CREATE INDEX ON UniVariation (var_str);
-CREATE INDEX ON UniVariation (univar_id ASC,subsnp_class);
+CREATE INDEX ON UniVariation (univar_id,subsnp_class);
CREATE INDEX ON VariAllele (allele_id);
-CREATE INDEX ON dn_gty2unigty_trueSNP (gty_id ASC,rev_flag);
+CREATE INDEX ON dn_gty2unigty_trueSNP (gty_id,rev_flag);