Skip to main content

Hi Experts,

What is the proper process for adding an index to a baseline FSM table?  For example, we may need to add an index on the User_def2 field on the table, ATTACHMENT.  

  1. What is the process?  
  2. Do we add the index ourselves with the knowledge that any FSM updates/upgrades in the future would most likely remove this index?  Or do we submit a ticket to CS to have them add the index?

Thanks in Advance !

Hi @Hushan Hasarel,

It is a direct database action that should be done by an experienced DBA after a thorough review to see if the index is required. It would not be an FSM action as such.

I do not believe the upgrades or updates touch the existing indexes they just remove and recreate the baseline ones.

Kind regards,

Lee Pinchbeck

Terms & ConditionsCookie settings