add human 9606 schema

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

diff --git a/schema/human_9606_schema/human_gty1_index.sql b/schema/human_9606_schema/human_gty1_index.sql
new file mode 100644 (file)
index 0000000..5dd05bf
--- /dev/null
+++ b/schema/human_9606_schema/human_gty1_index.sql
@@ -0,0 +1,53 @@
+ CREATE  INDEX [i_bs] ON [SubInd_ch1]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch1]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_ch2]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch2]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_ch3]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch3]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_ch4]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch4]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_ch5]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch5]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_ch6]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch6]([submitted_ind_id], [subsnp_id], [gty_id])
+GO
+
+
+ CREATE  INDEX [i_bs] ON [SubInd_ch7]([batch_id], [subsnp_id])
+GO
+
+ CREATE  INDEX [i_ind_ss] ON [SubInd_ch7]([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
+
+