re: Entity Framework Core performance tuning-part I

added by DotNetKicks
10/4/2017 2:02:50 PM

2 Kicks, 348 Views

There are only a few tens of thousands of records and the query is basically a bunch of index seeks and nested loop joins. But note that the way the query is structured forces the database to evaluate all possible results, then filter just the top few.