Can additional indices be added to the ActiveMatrix Administrator database, if recommended by a database administrator?

Can additional indices be added to the ActiveMatrix Administrator database, if recommended by a database administrator?

book

Article ID: KB0093246

calendar_today

Updated On: 01-13-2017

Products Versions
TIBCO ActiveMatrix Service Grid -
Not Applicable -

Description

Resolution:

Additional indices may not harm functionality but could have an impact on performance. A QUERY statement may be optimized but if a large number of INSERT, UPDATE and DELETE statements are carried out on the table then that could affect performance because of frequent updates having to be made on the index table. 


The default indices in the Administrator database are created based on tests completed by the TIBCO Performance QA team. Occasionally TIBCO may also suggest the addition of an index to fix a particular reported performance issue. In most cases, the default setting for the ActiveMatrix Database indices should be sufficient. 

A database administrator may suggests additional indices based on their expertise regarding optimization within the database they manage.  In this case it is recommend to apply the proposed changes in a lower environment of similar scale and compare the performance statistics collected.

Issue/Introduction

Can additional indices be added to the ActiveMatrix Administrator database, if recommended by a database administrator?