     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)
+  PRIMARY KEY (ORGANISMID) USING INDEX PK_BIOENTITY_ORGANISM
 ENABLE;
 
 -- Transcript expressions per gene for RNA-seq baseline experiments

    arraydesign  VARCHAR(255) NOT NULL
);

ALTER TABLE DESIGNELEMENT_MAPPING
  ADD CONSTRAINT PK_DESIGNELEMENT_MAPPING
  PRIMARY KEY (DESIGNELEMENT, IDENTIFIER, ARRAYDESIGN)
ENABLE;

-- Reference table for all bioentity organisms (across Ensembl and miRBase

    LAST_UPDATE DATE DEFAULT sysdate
);

CREATE INDEX PK_EXPERIMENT ON EXPERIMENT (ACCESSION) TABLESPACE ATLASPRD3_INDX;
ALTER TABLE EXPERIMENT
  ADD CONSTRAINT PK_EXPERIMENT
  PRIMARY KEY (ACCESSION) USING INDEX PK_EXPERIMENT
ENABLE;

exit;