add human 9606 schema

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

diff --git a/schema/human_9606_schema/human_gty2_index.sql b/schema/human_9606_schema/human_gty2_index.sql
new file mode 100644 (file)
index 0000000..480f2ff
--- /dev/null
+++ b/schema/human_9606_schema/human_gty2_index.sql
@@ -0,0 +1,172 @@
+ CREATE  INDEX [i_bs] ON [SubInd_ch10]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch10]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_ch11]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch11]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_ch12]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch12]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_ch13]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch13]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_ch14]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch14]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_ch15]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch15]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_ch16]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch16]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_ch17]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch17]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_ch18]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch18]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_ch19]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch19]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_ch20]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch20]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_ch21]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch21]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_ch22]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch22]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_ch8]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch8]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_ch9]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch9]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_chAltOnly]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_chAltOnly]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_chMT]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_chMT]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_chMulti]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_chMulti]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_batch_ss] ON [SubInd_chNewSs]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_chNewSs]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_chNotOn]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_chNotOn]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_chPAR]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_chPAR]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_chUn]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_chUn]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_chX]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_chX]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_chY]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_chY]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  CLUSTERED  INDEX [i_b_size] ON [dn_table_rowcount]([build_id] DESC , [reserved_KB_spaceused] DESC )
+GO
+
+