How can I increase the performance of BioSAR Browserwhen joining REGDB.REG_NUMBER to REGDB.BATCHNUMBERS?

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

Problem:

How can I increase the performance of BioSAR Browser when joining REGDB.REG_NUMBER to REGDB.BATCHNUMBERS?

Solution:

Indexing the BATCHES table in the REGDB schema will increase the performance of BioSAR Browser when joining REGDB.REG_NUMBER to REGDB.BATCH_NUMBERS.

To create the proper index, run the following script in SQLPlus Worksheet:

Connect regdb/oracle@SERVICE_NAME
create index INDEX_REG_INT_ID on BATCHES (
REG_INTERNAL_ID ASC);