Hi @TatSrikaD,

If you are on Azure then there is Azure functionality to identify and put in place beneficial indexes.

If not, SQL Server Management Studio can suggest indexes based off of the long running scripts in the system.

There is no generic guidance on indexes in FSM. There will be ones in baseline already and any additional ones will be specific to the environment depending on its use and setup including configuration and customisations.

Kind regards,

Lee Pinchbeck