X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Fshared_schema%2FdbSNP_main_index.sql;h=5040d46d192684cb410027a057575c5877de6a43;hb=77ec8a32a887e1eb6364f327f55049cae8e69f95;hp=7586c54eaa51a8919fc0a2d5fd8b6a708e1f951b;hpb=29955733afccef6bdefd2cfb746a2e4ae9e3b06a;p=dbsnp.git

diff --git a/schema/shared_schema/dbSNP_main_index.sql b/schema/shared_schema/dbSNP_main_index.sql
index 7586c54..5040d46 100644
--- a/schema/shared_schema/dbSNP_main_index.sql
+++ b/schema/shared_schema/dbSNP_main_index.sql
@@ -1,24 +1,19 @@
- CREATE  UNIQUE  INDEX [i_allele] ON [Allele]([allele])
+CREATE NONCLUSTERED INDEX [i_allele] ON [Allele] ([allele] ASC)
 GO
-
- CREATE  INDEX [i_rev_allele_id] ON [Allele]([rev_allele_id])
+CREATE NONCLUSTERED INDEX [i_rev_allele_id] ON [Allele] ([rev_allele_id] ASC)
 GO
 
 
-
- CREATE  INDEX [i_motif] ON [AlleleMotif]([motif_id])
+CREATE NONCLUSTERED INDEX [i_motif] ON [AlleleMotif] ([motif_id] ASC)
 GO
 
-
- CREATE  UNIQUE  CLUSTERED  INDEX [ind_AllocIds_name] ON [AllocIds]([name])
+CREATE CLUSTERED INDEX [ind_AllocIds_name] ON [AllocIds] ([name] ASC)
 GO
 
-
- CREATE  INDEX [i_auth] ON [Author]([author])
+CREATE NONCLUSTERED INDEX [i_auth] ON [Author] ([author] ASC)
 GO
 
-
- CREATE  UNIQUE  CLUSTERED  INDEX [i_ss] ON [Batch_tax_id]([batch_id])
+CREATE CLUSTERED INDEX [i_ss] ON [Batch_tax_id] ([batch_id] ASC)
 GO
 
 
@@ -26,129 +21,98 @@ GO
 
 
 
-
- CREATE  INDEX [i_unigty] ON [GtyAllele]([unigty_id])
+CREATE NONCLUSTERED INDEX [i_unigty] ON [GtyAllele] ([unigty_id] ASC)
 GO
-
- CREATE  INDEX [gty_id_idx] ON [GtyAllele]([gty_id])
+CREATE NONCLUSTERED INDEX [gty_id_idx] ON [GtyAllele] ([gty_id] ASC)
 GO
-
- CREATE  INDEX [i_gty_id] ON [GtyAllele]([gty_id])
+CREATE NONCLUSTERED INDEX [i_gty_id] ON [GtyAllele] ([gty_id] ASC)
 GO
 
 
-
- CREATE  INDEX [i_loaddate] ON [LoadHistory]([loaddate])
+CREATE NONCLUSTERED INDEX [i_loaddate] ON [LoadHistory] ([loaddate] ASC)
 GO
 
 
 
-
- CREATE  UNIQUE  INDEX [i_handle_loc_method_id] ON [Method]([handle], [loc_method_id])
+CREATE NONCLUSTERED INDEX [i_handle_loc_method_id] ON [Method] ([handle] ASC,[loc_method_id] ASC)
 GO
 
 
 
 
-
- CREATE  UNIQUE  INDEX [i_motif] ON [Motif]([motif])
+CREATE NONCLUSTERED INDEX [i_motif] ON [Motif] ([motif] ASC)
 GO
 
-
- CREATE  INDEX [i_obs] ON [ObsGenotype]([obs])
+CREATE NONCLUSTERED INDEX [i_obs] ON [ObsGenotype] ([obs] ASC)
 GO
-
- CREATE  INDEX [i_obs_upp_fix] ON [ObsGenotype]([obs_upp_fix])
+CREATE NONCLUSTERED INDEX [i_obs_upp_fix] ON [ObsGenotype] ([obs_upp_fix] ASC)
 GO
-
- CREATE  INDEX [i_gty_id] ON [ObsGenotype]([gty_id])
+CREATE NONCLUSTERED INDEX [i_gty_id] ON [ObsGenotype] ([gty_id] ASC)
 GO
 
-
- CREATE  UNIQUE  INDEX [i_pattern] ON [ObsVariation]([pattern])
+CREATE NONCLUSTERED INDEX [i_pattern] ON [ObsVariation] ([pattern] ASC)
 GO
-
- CREATE  INDEX [i_univar] ON [ObsVariation]([univar_id])
+CREATE NONCLUSTERED INDEX [i_univar] ON [ObsVariation] ([univar_id] ASC)
 GO
 
 
-
- CREATE  UNIQUE  CLUSTERED  INDEX [iuc_OrganismTax] ON [OrganismTax]([organism])
+CREATE CLUSTERED INDEX [iuc_OrganismTax] ON [OrganismTax] ([organism] ASC)
 GO
-
- CREATE  INDEX [i_tax_id] ON [OrganismTax]([tax_id])
+CREATE NONCLUSTERED INDEX [i_tax_id] ON [OrganismTax] ([tax_id] ASC)
 GO
-
- CREATE  INDEX [i_sp_tax] ON [OrganismTax]([species_tax_id])
+CREATE NONCLUSTERED INDEX [i_sp_tax] ON [OrganismTax] ([species_tax_id] ASC)
 GO
-
- CREATE  INDEX [i_dbname] ON [OrganismTax]([database_name])
+CREATE NONCLUSTERED INDEX [i_dbname] ON [OrganismTax] ([database_name] ASC)
 GO
 
 
 
-
- CREATE  UNIQUE  CLUSTERED  INDEX [i_handle_title] ON [Publication]([handle], [title])
+CREATE CLUSTERED INDEX [i_handle_title] ON [Publication] ([handle] ASC,[title] ASC)
 GO
 
 
-
- CREATE  INDEX [i_tax_id] ON [SNP_tax_id]([tax_id], [snp_id])
+CREATE NONCLUSTERED INDEX [i_tax_id] ON [SNP_tax_id] ([tax_id] ASC,[snp_id] ASC)
 GO
 
 
 
 
-
- CREATE  UNIQUE  CLUSTERED  INDEX [i_code] ON [SnpValidationCode]([code])
+CREATE CLUSTERED INDEX [i_code] ON [SnpValidationCode] ([code] ASC)
 GO
 
-
- CREATE  INDEX [i_abbrev_orien] ON [StrandCode]([abbrev], [rs_to_ss_orien], [code])
+CREATE NONCLUSTERED INDEX [i_abbrev_orien] ON [StrandCode] ([abbrev] ASC,[rs_to_ss_orien] ASC,[code] ASC)
 GO
 
-
- CREATE  UNIQUE  CLUSTERED  INDEX [i_comment_id] ON [SubSNPDelComm]([comment_id])
+CREATE CLUSTERED INDEX [i_comment_id] ON [SubSNPDelComm] ([comment_id] ASC)
 GO
 
 
-
- CREATE  UNIQUE  CLUSTERED  INDEX [iuc_Submitter] ON [Submitter]([handle])
+CREATE CLUSTERED INDEX [iuc_Submitter] ON [Submitter] ([handle] ASC)
 GO
-
- CREATE  INDEX [ic_Submitter] ON [Submitter]([name])
+CREATE NONCLUSTERED INDEX [ic_Submitter] ON [Submitter] ([name] ASC)
 GO
 
 
-
- CREATE  UNIQUE  INDEX [i_u_gty_str] ON [UniGty]([gty_str])
+CREATE NONCLUSTERED INDEX [i_u_gty_str] ON [UniGty] ([gty_str] ASC)
 GO
-
- CREATE  UNIQUE  INDEX [i_u_allele_ids] ON [UniGty]([allele_id_1], [allele_id_2])
+CREATE NONCLUSTERED INDEX [i_u_allele_ids] ON [UniGty] ([allele_id_1] ASC,[allele_id_2] ASC)
 GO
-
- CREATE  INDEX [i_allele_id_2] ON [UniGty]([allele_id_2])
+CREATE NONCLUSTERED INDEX [i_allele_id_2] ON [UniGty] ([allele_id_2] ASC)
 GO
 
-
- CREATE  INDEX [i_allele_id] ON [UniVariAllele]([allele_id])
+CREATE NONCLUSTERED INDEX [i_allele_id] ON [UniVariAllele] ([allele_id] ASC)
 GO
 
-
- CREATE  UNIQUE  INDEX [i_u_var_str] ON [UniVariation]([var_str])
+CREATE NONCLUSTERED INDEX [i_u_var_str] ON [UniVariation] ([var_str] ASC)
 GO
-
- CREATE  INDEX [cv_uvid_class] ON [UniVariation]([univar_id], [subsnp_class])
+CREATE NONCLUSTERED INDEX [cv_uvid_class] ON [UniVariation] ([univar_id] ASC,[subsnp_class] ASC)
 GO
 
 
-
- CREATE  INDEX [i_allele_id] ON [VariAllele]([allele_id])
+CREATE NONCLUSTERED INDEX [i_allele_id] ON [VariAllele] ([allele_id] ASC)
 GO
 
 
- CREATE  UNIQUE  INDEX [i_u] ON [db_DataDictionaryNew]([tab], [col_order])
-GO
 
 
 
@@ -156,11 +120,7 @@ GO
 
 
 
-
-
-
- CREATE  UNIQUE  CLUSTERED  INDEX [i_gty] ON [dn_gty2unigty_trueSNP]([gty_id], [rev_flag])
+CREATE CLUSTERED INDEX [i_gty] ON [dn_gty2unigty_trueSNP] ([gty_id] ASC,[rev_flag] ASC)
 GO
 
 
-