X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Fhuman_9606_schema%2Fhuman_gty2_index_postgresql.sql;h=bd28e29f3ed6ed9b85219c211958ec765ccf375e;hb=77ec8a32a887e1eb6364f327f55049cae8e69f95;hp=e4f03156b9d920c6478c1cb0d67f47eb75bc227b;hpb=6e51d2d339036d36e6294b1bbed27e5c18a6a2f5;p=dbsnp.git diff --git a/schema/human_9606_schema/human_gty2_index_postgresql.sql b/schema/human_9606_schema/human_gty2_index_postgresql.sql index e4f0315..bd28e29 100644 --- a/schema/human_9606_schema/human_gty2_index_postgresql.sql +++ b/schema/human_9606_schema/human_gty2_index_postgresql.sql @@ -1,123 +1,49 @@ - CREATE INDEX ON SubInd_ch10(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_ch10(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_ch11(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_ch11(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_ch12(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_ch12(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_ch13(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_ch13(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_ch14(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_ch14(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_ch15(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_ch15(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_ch16(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_ch16(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_ch17(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_ch17(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_ch18(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_ch18(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_ch19(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_ch19(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_ch20(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_ch20(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_ch21(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_ch21(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_ch22(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_ch22(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_ch8(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_ch8(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_ch9(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_ch9(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_chAltOnly(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_chAltOnly(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_chMT(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_chMT(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_chMulti(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_chMulti(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_chNewSs(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_chNewSs(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_chNotOn(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_chNotOn(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_chPAR(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_chPAR(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_chUn(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_chUn(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_chX(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_chX(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON SubInd_chY(batch_id, subsnp_id) -; - CREATE INDEX ON SubInd_chY(submitted_ind_id, subsnp_id, gty_id) -; - - CREATE INDEX ON dn_table_rowcount(build_id DESC , reserved_KB_spaceused DESC ) -; - +CREATE INDEX ON SubInd_ch10 (batch_id,subsnp_id); +CREATE INDEX ON SubInd_ch10 (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_ch11 (batch_id,subsnp_id); +CREATE INDEX ON SubInd_ch11 (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_ch12 (batch_id,subsnp_id); +CREATE INDEX ON SubInd_ch12 (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_ch13 (batch_id,subsnp_id); +CREATE INDEX ON SubInd_ch13 (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_ch14 (batch_id,subsnp_id); +CREATE INDEX ON SubInd_ch14 (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_ch15 (batch_id,subsnp_id); +CREATE INDEX ON SubInd_ch15 (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_ch16 (batch_id,subsnp_id); +CREATE INDEX ON SubInd_ch16 (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_ch17 (batch_id,subsnp_id); +CREATE INDEX ON SubInd_ch17 (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_ch18 (batch_id,subsnp_id); +CREATE INDEX ON SubInd_ch18 (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_ch19 (batch_id,subsnp_id); +CREATE INDEX ON SubInd_ch19 (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_ch20 (batch_id,subsnp_id); +CREATE INDEX ON SubInd_ch20 (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_ch21 (batch_id,subsnp_id); +CREATE INDEX ON SubInd_ch21 (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_ch22 (batch_id,subsnp_id); +CREATE INDEX ON SubInd_ch22 (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_ch8 (batch_id,subsnp_id); +CREATE INDEX ON SubInd_ch8 (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_ch9 (batch_id,subsnp_id); +CREATE INDEX ON SubInd_ch9 (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_chAltOnly (batch_id,subsnp_id); +CREATE INDEX ON SubInd_chAltOnly (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_chMT (batch_id,subsnp_id); +CREATE INDEX ON SubInd_chMT (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_chMulti (batch_id,subsnp_id); +CREATE INDEX ON SubInd_chMulti (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_chNewSs (batch_id,subsnp_id); +CREATE INDEX ON SubInd_chNewSs (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_chNotOn (batch_id,subsnp_id); +CREATE INDEX ON SubInd_chNotOn (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_chPAR (batch_id,subsnp_id); +CREATE INDEX ON SubInd_chPAR (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_chUn (batch_id,subsnp_id); +CREATE INDEX ON SubInd_chUn (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_chX (batch_id,subsnp_id); +CREATE INDEX ON SubInd_chX (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON SubInd_chY (batch_id,subsnp_id); +CREATE INDEX ON SubInd_chY (submitted_ind_id,subsnp_id,gty_id); +CREATE INDEX ON dn_table_rowcount (build_id DESC,reserved_KB_spaceused DESC);