U4-9188 - Remove unnecessary duplicate index IX_cmsPropertyData

Created by Shannon Deminick 16 Nov 2016, 07:20:13 Updated by Sebastiaan Janssen 16 Nov 2016, 09:19:04

Tags: Unscheduled

We have PK on cmsPropertyData.Id and for some reason have another non-clustered index on cmsPropertyData.Id too which is basically a complete duplicate.


Shannon Deminick 16 Nov 2016, 07:25:33

PR: https://github.com/umbraco/Umbraco-CMS/pull/1622

Test notes:

  • New installs of 7.5.5 will not have this duplicate index - test this
  • Ensure all tests pass
  • I have added a migration to remove this duplicate index, however this will only be applied to 7.6.0 versions since we can't change db schema for patch releases - ensure this doesn't execute for a 7.5.4 -> 7.5.5 upgrade

Priority: Normal

Type: Bug

State: Fixed


Difficulty: Normal


Backwards Compatible: True

Fix Submitted:

Affected versions:

Due in version: 7.5.5

Sprint: Sprint 46

Story Points: