Solved

Adding an index to a baseline FSM table

  • 7 July 2021
  • 1 reply
  • 187 views

Userlevel 4
Badge +11

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 !

icon

Best answer by Lee Pinchbeck 7 July 2021, 15:34

View original

This topic has been closed for comments

1 reply

Userlevel 7
Badge +24

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