Can we add addtional index to camunda tables

Camunda 7 Topics
1

Hi Team,
We are using camunda REST api to query/delete for historic process instances, task instances and variable instances. Everytime we will query with process variables and we are facing slowness in query response timing.

Db queries are taking more time to provide results as data is huge in terrabytes.

Can we add additional index, like compound indexex? will there be any impact of additional index

Appreciate the help,
thanks,
Gowtham

2

You could but then you have to conduct the tests yourself as to what the impact will be.

I would not store a huge amount of data in the Camunda DB.

3

what tables are you considering to add additional indexes? can you share them if you do end up adding indexes

4

HI @harish_malavade ,

Considering to add index to all history tables.