private void CreatePropertyDataIndexes() { // Creates a temporary index on umbracoPropertyData to speed up other migrations which update property values. // It will be removed in CreateKeysAndIndexes before the normal indexes for the table are created var tableDefinition = DefinitionFactory.GetTableDefinition(typeof(PropertyDataDto), SqlSyntax); Execute.Sql(SqlSyntax.FormatPrimaryKey(tableDefinition)).Do(); Create.Index("IX_umbracoPropertyData_Temp").OnTable(PropertyDataDto.TableName) .WithOptions().Unique() .WithOptions().NonClustered() .OnColumn("versionId").Ascending() .OnColumn("propertyTypeId").Ascending() .OnColumn("languageId").Ascending() .OnColumn("segment").Ascending() .Do(); }