Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

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

Rich Talbot
Date Posted:
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

Related articles