dotnet / dotnet/efcore

Temporal Table Indexes

Open
#28,368 3 comments 9 reactions 0 assignees View on GitHub
area-migrations area-model-building area-sqlserver area-temporal-tables customer-reported
Dominant language
C#
Stars
14.8k
Forks
3.4k
PR merge metrics
PR metrics pending

Description

I have been enjoying using the temporal table feature introduced in EF Core. However, the performance of queries in the history tables degrades quick significantly with time. To offset this I wanted to add some indexes to the history tables. I cannot find a way to add these in EF Core. Is there are way to add indexes to the history tables that I am missing? Or am I stuck managing indexes outside of EF Core migrations?

If this is no yet a feature in EF Core I would like to add this as a feature request.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.