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 optimizing indexes in Smart Instrumentation tables, make sure that in the Oracle Instance Configuration file, the OPTIMIZER_MODE parameter value is either CHOOSE (default) or COST.  This way, you activate the Oracle Cost-based Optimizer, which determines the quality of the Smart Instrumentation database performance.

  • 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 > Tuning >Optimize Indexes.

  2. From the Domain list, select the domain in which you want to optimize indexes.

    • The Fragmentation column displays the number of Extents of each index.

    • It is recommended to optimize all database indexes whose fragmentation level is higher than 4.

  3. Do one of the following:

    • Click All tables to optimize the indexes for all the tables in the selected domain.

    • Click Selected tables to display in the data window all the tables in the current domain and optimize the indexes for the required tables.

  4. Click OK to start the optimization process.

 To enable better performance after completing the index optimization process, you need to update statistics.  Without updating statistics, the Oracle Cost-based Optimizer cannon use the reordered indexes.