Queries running slowly?

Consider adding an index.

Indexes help SQL Server:

• Find data faster
• Reduce table scans
• Improve filtering performance
• Improve sorting performance
• Improve join performance

Not every column needs an index, but columns used in WHERE clauses often benefit from one.

What is your favorite indexing strategy?

Want asynchronous database writes in EF Core?

Use SaveChangesAsync() instead of SaveChanges().

Benefits:

• Doesn't block the calling thread
• Works better under load
• Integrates with async/await
• Recommended for ASP.NET Core applications
• Available since EF Core was released

What other EF Core performance tips do you use?