sql-server - EF Core 不断抱怨不存在的索引

Question

我在运行时收到了来自 EF Core 的一堆日志抱怨，如下所示：

[10:56:14 DBG] The index {'InvoiceId'} was not created on entity type 'CompleteCase' as the properties are already covered by the index {'InvoiceId', 'Code'}.
[10:56:14 DBG] The index {'ReportPeriodId'} was not created on entity type 'FixedBill' as the properties are already covered by the index {'ReportPeriodId', 'MedCompanyTypeId', 'FixedBillTypeId'}.
[10:56:14 DBG] The index {'CasePeriodId'} was not created on entity type 'Invoice' as the properties are already covered by the index {'CasePeriodId', 'ReportPeriodId', 'MedCompanyTypeId'}.
[10:56:14 DBG] The index {'InvoiceId'} was not created on entity type 'InvoiceFixedBillMap' as the properties are already covered by the index {'InvoiceId', 'FixedBillId'}.
[10:56:14 DBG] The index {'MedCompanyDepartmentTypeId'} was not created on entity type 'MedCompanyDepartmentDoctorMap' as the properties are already covered by the index {'MedCompanyDepartmentTypeId', 'MedCompanyDoctorTypeId', 'DoctorSpecialtyTypeId', 'StartDate', 'EndDate'}.
[10:56:14 DBG] The index {'VMPMethodTypeId'} was not created on entity type 'VMPMethodMKBMap' as the properties are already covered by the index {'VMPMethodTypeId', 'MKBTypeId'}.
[10:56:14 DBG] The index {'KSGBaseRateTypeId'} was not created on entity type 'KSGBaseRate' as the properties are already covered by the index {'KSGBaseRateTypeId', 'StartDate', 'EndDate'}.
[10:56:14 DBG] The index {'KSGTypeId'} was not created on entity type 'KSGIndexRate' as the properties are already covered by the index {'KSGTypeId', 'KSGIndexTypeId', 'StartDate', 'EndDate'}.
[10:56:14 DBG] The index {'MedCompanyTypeId'} was not created on entity type 'MedCompanyKSGIndexRate' as the properties are already covered by the index {'MedCompanyTypeId', 'MedCompanyUnitTypeId', 'MedCompanyDepartmentTypeId', 'UMPTypeId', 'KSGIndexTypeId', 'StartDate', 'EndDate'}.
[10:56:14 DBG] The index {'UserId'} was not created on entity type 'UserRole' as the properties are already covered by the index {'UserId', 'RoleId'}.
[10:56:14 DBG] The index {'UserId'} was not created on entity type 'IdentityUserToken<Guid>' as the properties are already covered by the index {'UserId', 'LoginProvider', 'Name'}.

我可以看到这些的原因 - 因为有使用这些列的复合索引，它们使单独的索引无用。这些列都是外键，EF Core 在迁移过程中自动创建。

但是这些索引实际上都不存在于迁移或数据库本身中（代码优先）。我已经非常仔细地检查了。甚至删除了所有迁移并从头开始创建它们 - 没有。但是在运行时我每次都会得到这些。

是否可以忽略或者应该从我这边采取一些行动？

PS 使用 SQL Server 作为数据库提供程序在 3.1.8 上测试。

标签： sql-serverentity-framework-coreforeign-keysrelational-databaseentity-framework-migrations

Answer 1

但是这些索引实际上都不存在于迁移或数据库本身中（代码优先）。

当然他们没有，你在这里看到的只是一个警告，告诉你一些索引已从模型中删除（忽略）。可能令人困惑的部分是您没有明确请求此类索引，正如您所说，它们是由 EF 自动创建的（顺便说一句，不能从外部删除），因此 EF Core 不应该警告您。

但是它就是这样啊。不为另一个索引前导的列生成索引是完全可以的。您可以放心地忽略它，并通过添加以下内容来OnConfiguring覆盖它：

optionsBuilder.ConfigureWarnings(warnings => warnings
    .Ignore(CoreEventId.RedundantIndexRemoved);