EF Core 11 makes your split queries faster

This article explains how EF Core 11 enhances split query performance by removing redundant reference navigation JOINs from collection queries. In earlier versions, using AsSplitQuery with multiple Includes caused extra JOINs and ORDER BY columns in collection queries, degrading performance. EF Core 11 (preview 3+) prunes these unnecessary joins, resulting in cleaner, faster queries. Benchmarks comparing EF Core 10 and 11 show significant improvements. The article includes code examples, SQL query comparisons, and a disclaimer about benchmark variables.