Support for adding custom indexes to the ePO database

Technical Articles ID: KB73614
Last Modified: 2022-03-02 00:57:32 Etc/GMT

Environment

ePolicy Orchestrator (ePO) 5.x

Summary

We try to ensure that product performance meets your needs by providing the needed database indexes. Despite this, adding specific indexes to the ePO database might improve performance. But, it is impossible to proactively ensure compatibility with every possible combination of other indexes.

So, it is entirely your responsibility to remove all custom-added indexes in the following instances:

During escalation as requested from Technical Support.
Before you install any of the below listed items, for your created database tables that are modified with your specific indexes:
- A Proof of Concept build
- Hotfix
- ePO update
- A new product version

After you apply a software upgrade, you can add your custom indexes back to the system if needed.

There are performance trade-offs when you add indexes. For example, creating an index to improve dashboard performance could reduce performance when inserting events into the database. It is your responsibility to rectify any performance issues introduced by adding custom indexes.

Affected Products

ePolicy Orchestrator 5.10.x

Languages:

This article is available in the following languages:

Knowledge Center

Support for adding custom indexes to the ePO database

Environment

Summary

Affected Products

Languages:

Title

Title

Knowledge Center

Support for adding custom indexes to the ePO database

Environment

Summary

Affected Products

Languages:

Choose your region

Title

Title