How can I increase the performance of BioSAR Browserwhen joining Registration System and BioAssay HTS tables?

Created
October 08, 2021 23:01

Date Posted: 2004-02-20
Product: ChemBioOffice Enterprise

Problem:

How can I increase the performance of BioSAR Browser when joining Registration System and BioAssay HTS tables?

Solution:

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:

Connect regdb/oracle@SERVICE_NAME
create index INDEX_REG_NUM on REG_NUMBERS (
REG_NUMBER ASC);

where SERVICE_NAME is the Oracle service name the regdb schema is located