Sfoglia categorie
Esplora
Fiverr Pro
Italiano
$
USD
I will optimize one slow sql query for better performance
Senior Data Engineer and BI Specialist
Senior data engineer and BI specialist with 17+ years of experience building scalable data warehouses, reliable pipelines, and high-impact reporting solutions across advertising, retail, real estate, ...
Informazioni su questo servizio
Do you have an SQL query that is slow, timing out, or scanning too much data?
I have 17+ years of experience building and optimising scalable data systems, reporting platforms, and databases handling large volumes of data.
I will review your query and suggest practical ways to improve its performance. This may include query rewriting, index recommendations, execution plan review, table structure observations, or filtering/join improvements.
This gig is ideal for a focused review of one problematic query. If your issue involves many slow queries, high CPU, poor MySQL configuration, or wider database performance problems, please contact me first or check my MySQL database optimisation gig.
Tipo di database:
Database relazionale
Piattaforma:
BigQuery
•
MySQL
•
PostgreSQL
•
SQL server
Expertise:
SQL
•
Performance
•
Ottimizzazione query
FAQ
What do I need to provide?
Please provide the SQL query, database type/version, table structure, indexes, approximate row counts, current execution time, and the expected result. If available, also include the EXPLAIN or execution plan.
Do you need database access?
Not always. I can often review the query using the SQL, schema, indexes, and execution plan. Read-only access can help if deeper analysis is needed.
Can you guarantee that the query will run faster?
I cannot guarantee a specific speed improvement. I will provide practical recommendations based on the query, schema, and execution plan. If the query is already optimised, I'll explain why it is so and try to suggest alternatives.
Is this gig for one query only?
Yes. This gig is for reviewing one SQL query. If you have multiple slow queries or wider database performance issues, please contact me first or check my MySQL database optimisation gig.
What kind of improvements might you suggest?
Recommendations may include query rewriting, better indexes, join improvements, filtering changes, execution plan observations, or table structure suggestions.
Can you make the changes directly?
I provide analysis and recommendations. Direct changes require suitable access and my familiarity with the programming language (for apps) or tools where used. Please check before ordering.
Which databases do you support?
I can review queries for MySQL, MS SQL Server, PostgreSQL, and BigQuery.
Recensioni
1 recensioni per questo servizio
| (1) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Valutazione dettagliata
- Livello di comunicazione del venditore
- Qualità della consegna
- Valore della consegna
Ordina per
Più rilevante
H hafeel89
Emirati Arabi Uniti
The quert works fine. Thank you for the exceptional support.
50 USD
Prezzo
1 giorno
Tempo
Utile?
Recensioni
1 recensioni per questo servizio
| (1) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Valutazione dettagliata
- Livello di comunicazione del venditore
- Qualità della consegna
- Valore della consegna
Ordina per
Più rilevante
H hafeel89
Emirati Arabi Uniti
The quert works fine. Thank you for the exceptional support.
50 USD
Prezzo
1 giorno
Tempo
Utile?
