Optimize EF Core Database Query Performance

In a project where PDFs were migrated from a Blob Storage container to a SQL Server database, the web app's performance dropped significantly. To address this, several strategies were used to optimize EF Core query performance: using AsSplitQuery to avoid data duplication, employing projections and DTOs for read-only data to retrieve only necessary columns, and creating indexes for frequently queried non-primary key fields. These optimizations led to a reduction in response times and overall improved performance.