Azure SQL DB Index Recommendations

Microsoft

For the SQL Azure Databases in multiple regions and multiple subscriptions, we keep getting recommendations/warning regarding the addition of indexes is required, but those recommendations are implemented already and those indexes exist. We understand that manually applied recommendations will remain active and shown in the list of recommendations for 24-48 hrs. before the system automatically withdraws them but it's a recurring issue for them and is causing lot of churn.
Basically we want to understand if the recommendation has already been applied why is the base issue not resolved? Will they be there forever or is there a way to force the recommendation to be evaluated again. Thanks.

0 Replies