I will optimize slow oracle plsql and sql server queries and stored procedures
SAP ISU, Oracle and SQL Server Expert, AI Text to SQL Developer
About this Gig
Slow reports, timeouts and heavy stored procedures cost you time and money. I find out why and fix it.
I have 18+ years of hands-on SQL work, including 13 years on large utility databases (SAP IS-U, billing and meter data), and I am an Oracle Certified PL/SQL Associate. I work on both Oracle (PL/SQL) and Microsoft SQL Server (T-SQL).
What you get:
- Analysis of the execution plan to find the real bottleneck
- Rewritten query or procedure, plus index changes where they help
- Before and after timings measured on your data
- A short note explaining every change
I work on a test copy or with read-only access, and never change production without your approval. Please message me before ordering with your database type and the slow query.
Database type:
Relational database
Platform:
MS SQL
•
Oracle
•
PL/SQL
•
SQL Server
Expertise:
Data warehouse
•
SQL
•
Performance
•
Query optimization
My Portfolio
FAQ
Which databases do you work with?
Oracle (PL/SQL) and Microsoft SQL Server (T-SQL).
Do you need access to my production database?
No. A test copy, the slow query and its execution plan are usually enough. Please never send production passwords.
What if the query cannot be made faster?
I will explain why and what would help instead, such as design, data or hardware changes.
