X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Fhuman_9606_schema%2Fhuman_gty2_index.sql;h=3b24325f537737d0cadcd2b5efa5933d50431a76;hb=77ec8a32a887e1eb6364f327f55049cae8e69f95;hp=480f2ff6070ed3ea244724e49ae6b512fb72362c;hpb=ea7460b34b8123c023d3f73296a9cb5f7703abbe;p=dbsnp.git

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