Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Jason Elkin 38 posts 351 karma points MVP 3x c-trib
    Oct 10, 2017 @ 09:14
    Jason Elkin
    0

    Azure SQL "index recommendation"

    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?

Please Sign in or register to post replies

Write your reply to:

Draft