Product: ChemBioOffice Enterprise
How can I increase the performance of BioSAR Browser when joining Registration System and BioAssay HTS tables?
Indexing the REG_NUMBERS table in the REGDB schema will increase the performance of BioSAR Browser when joining BioAssay HTS tables to Registration System tables.
To create the proper index, run the following script in SQLPlus Worksheet:
create index INDEX_REG_NUM on REG_NUMBERS (
- where SERVICE_NAME is the Oracle service name the regdb schema is located