I have a number of Umbraco sites running in Azure with Azure SQL and occasionally I get an email come through from the Azure SQL Database Advisor with the following suggestion:

Target object: [dbo].[cmsDocument]
Recommended action: CreateIndex
Indexed columns: [published], [nodeId]
Estimated Index Impact: HIGH IMPACT

Is it safe to do this? Would this result in a genuine performance gain?

I'm no DBA, and not very familiar with Umbraco's database design so I'm not sure of the implications. Most importantly I don't want to break the upgrade path.

Any help would be great.

Also, if this is a genuine performance gain then I presume it would make sense to include this in Umbraco itself?