Skip to main content

How do I ANALYZE my ChemOffice Webserver application Schema?

Rich Talbot
  • Created
Date Posted:
Product: ChemBioOffice Enterprise

Problem:

How do I ANALYZE my ChemOffice Webserver application Schema?


Solution:

CambridgeSoft recommends database administrators ANALYZE the CambridgeSoft Oracle schemas after periods of significant data change. This could be after loading large amounts of data into BioAssay HTS, or bulk-loading data into the Registration System. We also recommend that you ANALYZE our schemas after first installing the software.

ANALYZE allows Oracle to make the best decisions about joining data, and can dramatically improve BioSAR Browser performance.

  1. Open DBA Studio
  2. Login to your database as system, with the system password.
  3. Choose Tools->Analyze.
  4. Accept the defaults on the first screen. Click Next.
  5. Select the objects you want to Analyze. 
    We recommend you choose BIOASSAYHTS and REGDB. 
  6. Click Next.
  7. Accept the defaults on this screen. Click Next.
  8. You will see the SQL that is to be run. For future use, you may copy this SQL to a script file and run it on a periodic basis. Click Finish.
    The Analyze operation is run.

Comments

0 comments

Article is closed for comments.