--- title: "EF Core 11 makes your split queries faster" url: https://daily.dev/posts/ef-core-11-makes-your-split-queries-faster-t9ltozeyp source_url: https://steven-giesel.com/blogPost/d4401fd0-805a-4703-9d9e-5fe3b57c25ea type: article source: "We Are .NET" published: 2026-06-08T06:23:35.134Z updated: 2026-08-24T06:53:35.276Z tags: [".net", "sqlite"] reading_time: 4 upvotes: 22 comments: 1 language: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # EF Core 11 makes your split queries faster **[We Are .NET](https://daily.dev/sources/wearedotnet)** · 4 min read · 22 upvotes · 1 comments ## Summary EF Core 11 (since preview 3) optimizes split queries by pruning unnecessary reference navigation JOINs from collection queries. Previously, when using AsSplitQuery with both reference and collection navigations, each collection query would redundantly JOIN and ORDER BY all reference navigation tables. EF Core 11 removes these superfluous JOINs, producing leaner SQL closer to what a developer would write by hand. Benchmarks comparing .NET 10 vs .NET 11 show roughly a 9% reduction in execution time (68.5ms → 62ms) and about 10% less memory allocation (33.35MB → 30.15MB) for a dataset of 5,000 blogs with 5 posts each. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [EF Core Performance Best Practices in .NET 10](https://daily.dev/posts/ef-core-performance-best-practices-in-net-10-syq7fm9cv) · We Are .NET · 55 upvotes · 4 comments --- Tags: [#.net](https://daily.dev/tags/.net), [#sqlite](https://daily.dev/tags/sqlite) [View this post on daily.dev](https://daily.dev/posts/ef-core-11-makes-your-split-queries-faster-t9ltozeyp)