  )
 PARALLEL;
 
+CREATE INDEX PK_RNASEQ_BSLN_TRANSCRIPTS ON RNASEQ_BSLN_TRANSCRIPTS (EXPERIMENT, GENE_IDENTIFIER, TRANSCRIPT_IDENTIFIER, ISACTIVE) TABLESPACE ATLASPRD3_INDX;
 ALTER TABLE RNASEQ_BSLN_TRANSCRIPTS
   ADD CONSTRAINT PK_RNASEQ_BSLN_TRANSCRIPTS
-  PRIMARY KEY (EXPERIMENT, GENE_IDENTIFIER, TRANSCRIPT_IDENTIFIER, ISACTIVE)
+  PRIMARY KEY (EXPERIMENT, GENE_IDENTIFIER, TRANSCRIPT_IDENTIFIER, ISACTIVE) USING INDEX PK_RNASEQ_BSLN_TRANSCRIPTS
 ENABLE;
 
 -- Experiment table

 )
PARALLEL;

ALTER TABLE MICROARRAY_DIFF_ANALYTICS
  ADD CONSTRAINT PK_MICROARRAY_DIFF_ANALYTICS
  PRIMARY KEY (DESIGNELEMENT, EXPERIMENT, CONTRASTID, PVAL, ISACTIVE)
ENABLE;

CREATE INDEX MICROARRAY_DIFF_ANALYTICS_IDX ON MICROARRAY_DIFF_ANALYTICS (ISACTIVE, EXPERIMENT, CONTRASTID) COMPRESS LOCAL (

    name VARCHAR(255) NOT NULL
);

CREATE INDEX PK_BIOENTITY_ORGANISM ON BIOENTITY_ORGANISM (ORGANISMID) TABLESPACE ATLASPRD3_INDX;
ALTER TABLE BIOENTITY_ORGANISM
  ADD CONSTRAINT PK_BIOENTITY_ORGANISM
  PRIMARY KEY (ORGANISMID) USING INDEX PK_BIOENTITY_ORGANISM
ENABLE;

-- Transcript expressions per gene for RNA-seq baseline experiments
