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. What is the process? 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 !

Solved

Adding an index to a baseline FSM table

5 years ago
Jul 7, 2021 12:06 PM UTC
1 reply
249 views

+12

Hushan Hasarel
Hero (Employee)

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.

What is the process?
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 !

Best answer by Lee Pinchbeck

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

View original

This topic has been closed for replies.

+24

Lee Pinchbeck
Ultimate Hero
Answer
5 years ago
Jul 7, 2021 1:34 PM UTC

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

Currently reading: The Way of Kings - Brandon Sanderson

Like

Did you find what you're looking for? If not:

Sign up

Login to the community