I will optimize your slow sql queries for better performance

As a Database and SQL tuning expert with more than 20+ years working experience, I feel confident to optimize any SQL queries with poor performance in below databases:

• Oracle (SQL and PL/SQL packages)
• PostgreSQL (SQL and pl/pgsql stored procedure)
• SQL Server (SQL, T-SQL and Stored procedure)
• mysql (SQL)

The way to optimize SQL queries including:

• Examining the execution plan to identify the root cause of sub-optimal plan
• Identifying the missing or inappropriate indexes.
• Adding SQL Hints (in Oracle, SQL Server and mysql)
• SQL rewriting to gain better access path and/or join algorithm.
• and more....

The delivery document including:

• Problematic SQL query analyzing.
• Recommendation of SQL query optimization and the explanation of why.
• Round-trip communication and follow-up instruction until the performance issue fixed or remedy solution take in place.

Packages scope description:

• Basic: Optimizing 1 SQL query, delivery within 1 day
• Standard: Optimizing 3-5 SQL queries, or 1 stored procedure/function, delivery within 3 days.
• Premium: Optimizing 5-10 SQL queries, or 3-5 stored procedure/function, delivery within 5 days.

Look forward to work with you.