X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Fhuman_9606_schema%2Fhuman_gty1_index.sql;fp=schema%2Fhuman_9606_schema%2Fhuman_gty1_index.sql;h=6eeeb7d516e3cb573b5e730e608dff67ae09af57;hb=77ec8a32a887e1eb6364f327f55049cae8e69f95;hp=5dd05bf316cfc745ca8b9c6913d0589ccb432cae;hpb=6e51d2d339036d36e6294b1bbed27e5c18a6a2f5;p=dbsnp.git

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