EF Core 11 Speeds Up Split Queries by Removing Unnecessary Joins

EF Core 11 makes your split queries faster

I discovered that EF Core 11 significantly improves performance for split queries by pruning unnecessary reference navigation joins from collection queries. Previously, every collection query dragged along extra joins and order-by columns, wasting database resources. Now, the generated SQL is cleaner and more efficient, resulting in faster execution times and fewer memory allocations compared to EF Core 10.

"The database does the work, throws the result away, and your query plan suffers for it."