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

Forum|Forum|4 years ago
July 7, 2021
1 reply
232 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

This topic has been closed for replies.

+24

Lee Pinchbeck
Ultimate Hero
Answer
Forum|Forum|4 years ago
July 7, 2021

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

Scanning file for viruses.

This file cannot be downloaded