Temporal Table Indexes
Open
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
Assessment
This issue has not been assessed yet.