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.