     name VARCHAR(255)
 );
 
+CREATE INDEX PK_BIOENTITY_NAME ON BIOENTITY_NAME (IDENTIFIER, ORGANISMID, TYPE) TABLESPACE ATLASPRD3_INDX;
 ALTER TABLE BIOENTITY_NAME
   ADD CONSTRAINT PK_BIOENTITY_NAME
-  PRIMARY KEY (IDENTIFIER, ORGANISMID, TYPE)
+  PRIMARY KEY (IDENTIFIER, ORGANISMID, TYPE) USING INDEX PK_BIOENTITY_NAME
 ENABLE;
 
 -- miRBase and Ensembl design element to gene mappings

 )
PARALLEL;

ALTER TABLE RNASEQ_BSLN_TRANSCRIPTS
  ADD CONSTRAINT PK_RNASEQ_BSLN_TRANSCRIPTS
  PRIMARY KEY (EXPERIMENT, GENE_IDENTIFIER, TRANSCRIPT_IDENTIFIER, ISACTIVE)
ENABLE;

-- Experiment table

 )
PARALLEL;

CREATE INDEX PK_RNASEQ_DIFF_ANALYTICS ON RNASEQ_DIFF_ANALYTICS (IDENTIFIER, EXPERIMENT, CONTRASTID, PVAL, ISACTIVE) TABLESPACE ATLASPRD3_INDX;
ALTER TABLE RNASEQ_DIFF_ANALYTICS
  ADD CONSTRAINT PK_RNASEQ_DIFF_ANALYTICS
  PRIMARY KEY (IDENTIFIER, EXPERIMENT, CONTRASTID, PVAL, ISACTIVE) USING INDEX PK_RNASEQ_DIFF_ANALYTICS
ENABLE;

CREATE INDEX RNASEQ_DIFF_ANALYTICS_IDX ON RNASEQ_DIFF_ANALYTICS (IDENTIFIER, ISACTIVE, EXPERIMENT, CONTRASTID) COMPRESS LOCAL (
     PARTITION  DIFF_ANALYTICS_ACTIVE TABLESPACE ATLASPRD3_INDX
