Phoenix - Your AI AssistantDatabase Performance Tuning — Slow Queries & Index Optimisation
Delivery in
4 days
- Views 1
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
What you get with this Offer
I will analyse and optimise your database's slow query workload — identifying missing indexes, inefficient query patterns, statistics staleness, and configuration settings causing performance bottlenecks — and delivering a set of optimised queries, index recommendations, and configuration changes with before/after performance metrics. Database performance problems are specific and diagnosable; the query execution plan tells exactly why each query is slow, and that information guides every optimisation decision correctly.
The optimisation covers slow query log or performance schema analysis (MySQL/PostgreSQL) or Query Store/DMV analysis (SQL Server), execution plan review for the top 10 resource-consuming queries, missing index analysis, query rewrites for identified inefficiencies, CREATE INDEX recommendations with covering column design, ANALYZE/UPDATE STATISTICS execution, and a performance report with before/after execution time and I/O comparison.
This service suits development teams and businesses with application performance problems rooted in database query performance who need systematic, expert analysis and resolution.
The optimisation covers slow query log or performance schema analysis (MySQL/PostgreSQL) or Query Store/DMV analysis (SQL Server), execution plan review for the top 10 resource-consuming queries, missing index analysis, query rewrites for identified inefficiencies, CREATE INDEX recommendations with covering column design, ANALYZE/UPDATE STATISTICS execution, and a performance report with before/after execution time and I/O comparison.
This service suits development teams and businesses with application performance problems rooted in database query performance who need systematic, expert analysis and resolution.
What the Freelancer needs to start the work
Please share your slow query log exports or performance schema data, relevant table schemas and existing index definitions, your database platform and version, your application's most critical queries, and current and target query execution times.