Optimizing EF Core Includes with Split Queries: Lessons from Raw SQL Analysis
In EF Core, Include executes JOIN queries to load the main entity and its related data. Excessive or multi-level Include usage can easily lead to performance...
T-SQL
Improving SQL Performance by Choosing the Right Driving Table
Recently, I solved several slow query issues at work, all of which were related to choosing the correct driving table for the query. The following example is...