Azure Portal recommendation on index for SonarQube Enterprise 8.9.6

SonarQube
1

We are using SonarQube Enterprise 8.6.6. we are hosting SonarQube Enterprise on Azure AKS and Azure SQL Server and getting below performance recommendation of creation of indexes from Azure in Azure SQL Server.

  • Could you please review below recommendation and provide your comments on this?
  • If we make the index update as per Azure recommendation will this affect the future upgrades of SonarQube Enterprise?

image
image693×317 19.5 KB

Below are the SonarQube details:-
SonarQube ID information
Version: 8.9.6.50800
image

2

You should not alter the database to alter indices – this can interfere with future upgrades (if we decide to add an index where one already exists, or drop a column that you are using in an index).

If you are facing any specific performance issues – let us know! Otherwise, leave the database alone.