Optimize Indexes - Intergraph Smart Instrumentation - 13.1 - Administration & Configuration - Hexagon PPM

Intergraph Smart Instrumentation Administration

PPMProduct
Intergraph Smart Instrumentation
PPMCategory_custom
Administration & Configuration
Version_SPI_custom
13.1

 Before starting the optimization process, make sure that no other user is using the currently selected domain.  If you attempt to optimize the indexes of a domain which is currently being used by another user, the software displays a message warning you that the domain is currently in use.

  1. With the System Administration window open, click DBA > Optimize Indexes.

  2. From the Domain list, select the required domain.

  3. Do one of the following to define the tables you want to include in the optimization process:

    • Click All tables to optimize the indexes of all the existing tables in the defined domain.

    • Click Selected tables to display the database indexes in the Table Name data window and optimize the indexes of the highlighted tables in the defined domain.

  4. Do one of the following to define the index source on which you base the optimization:

    • Click Current database to optimize indexes using the current database indexes.

    • Click Template database to optimize indexes using the IN_TEMPL.DDTI template database indexes.  Use the Template database option if your current database indexes have been deleted or become unusable.

  5. Click OK.

 To enable better performance after completing the index optimization process, you need to update statistics.  Start the Query Analyzer and run the SP_UPDATESTATS procedure.