[Obo-svn-commit] SF.net SVN: obo:[2961] OBDAPI/trunk/sql/phenoscape/obd-phenoscape-schema. sql

[<car...@us...>]

Revision: 2961
          http://obo.svn.sourceforge.net/obo/?rev=2961&view=rev
Author:   cartik73
Date:     2009-12-17 16:42:39 +0000 (Thu, 17 Dec 2009)

Log Message:
-----------
One more B+ tree index on phenotype table in the data warehouse

Modified Paths:
--------------
    OBDAPI/trunk/sql/phenoscape/obd-phenoscape-schema.sql

Modified: OBDAPI/trunk/sql/phenoscape/obd-phenoscape-schema.sql
===================================================================
--- OBDAPI/trunk/sql/phenoscape/obd-phenoscape-schema.sql	2009-12-16 16:15:48 UTC (rev 2960)
+++ OBDAPI/trunk/sql/phenoscape/obd-phenoscape-schema.sql	2009-12-17 16:42:39 UTC (rev 2961)
@@ -402,6 +402,8 @@
 
 CREATE INDEX dw_phenotype_entity_character_index ON dw_phenotype_table(inheres_in_entity_nid, character_nid);
 
+CREATE INDEX dw_phenotype_nid_index ON dw_phenotype_table(phenotype_nid); 
+
 CREATE TABLE dw_gene_genotype_phenotype_table (
 gene_nid INTEGER REFERENCES dw_gene_table(gene_nid) ON DELETE CASCADE, 
 genotype_nid INTEGER REFERENCES dw_genotype_table(genotype_nid) ON DELETE CASCADE, 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.