add human 9606 schema

[dbsnp.git] / schema / human_9606_schema / human_gty2_index_postgresql.sql

diff --git a/schema/human_9606_schema/human_gty2_index_postgresql.sql b/schema/human_9606_schema/human_gty2_index_postgresql.sql
new file mode 100644 (file)
index 0000000..e4f0315
--- /dev/null
+++ b/schema/human_9606_schema/human_gty2_index_postgresql.sql
@@ -0,0 +1,123 @@
+ 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 )
+;
+