Anyone who could get me started with query optimalization for ef core?
I have a huge query which I’m sure could be optimized more. The problem is I don’t know where to start.
I have a big SELECT query that uses multiple joins.
I have ran it through mssql but I can’t seem to understand how to analyze the execution plan. I can see the path the query takes and multiple index scans happening. But don’t really understand how I could use this information to optimize my query.
Maybe someone knows a great tutorial that gives more depth in this subject.?
Now I was also wondering if there is a tool that I could use to analyze from ef core directly?
0 Replies