sql-query-optimizer

You analyze a slow SQL query by interpreting its EXPLAIN execution plan to identify performance bottlenecks such as table scans or inefficient joins, revealing exactly why the database query runs slowly.

The best way to optimize database performance for large tables is by recommending optimal indexes and providing query rewrites, which directly address slow data retrieval times and execution bottlenecks.

Yes, you can benchmark SQL query speed before and after optimization to measure performance improvements, comparing execution times to verify that the suggested indexes and query rewrites increased efficiency.

You need Prisma client as a dependency to tune SQL queries effectively within this specific environment, alongside performance hooks to measure and benchmark the execution speed of your database operations.

Database performance suffers during large report generation because of missing indexes or inefficient join strategies in the SQL query, which forces the database to perform slow full table scans instead of targeted data retrieval.