Enhance database query performance - EcoSys - Administration & Configuration - Hexagon PPM

EcoSys System Administration

Language
English
Product
EcoSys
Search by Category
Administration & Configuration
EcoSys Version
8.7

For Oracle databases, it is possible to use materialized views to enhance database query performance. To create the materialized view on the base tables, run the optional fm_or_materializedview_0600_0001_to_0600_0002.sql script.

In order for EcoSys to utilize materialized views, you must also set the parameter to True. If you set the parameter to False or if the parameter does not exist, materialized views will not be used.

database.useMaterializedViews=true

  • The optional script for creating the materialized view is located within the EcoSys package under database\oracle\upgrades.

  • For more detailed guidance on Oracle settings, refer to the EcoSys Performance Tuning Guide.